Sideway
output.to from Sideway
Draft for Information Only

Content

ASP.NET Useful References
 SQL and ASP.NET
 SQL and ASP.NET
 ASP.NET, SQL, and Web.Config

ASP.NET Useful References

SQL and ASP.NET

  • sql-server-samples/samples/databases/northwind-pubs at master · microsoft/sql-server-samples · GitHub https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs
  • Downloading Northwind and pubs Sample Databases for previous versions. Default folder: C:\SQL Server 2000 Sample Databases. https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms143221(v=sql.105)?redirectedfrom=MSDN
  • Upgrading a database file (.mdf) after you install a newer version of Visual Studio. https://docs.microsoft.com/en-us/visualstudio/data-tools/upgrade-dot-mdf-files?view=vs-2019&redirectedfrom=MSDN&viewFallbackFrom=vs-2015
  • Northwind.mdf - This database file is not compatible with the current instance of SQL Server (in Visual Studio 2017) https://stackoverflow.com/questions/46307886/northwind-mdf-this-database-file-is-not-compatible-with-the-current-instance-o/52960253
  • Northwind and pubs Sample Databases for SQL Server 2000 http://web.archive.org/web/20130101054855/https://www.microsoft.com/en-us/download/details.aspx?id=23654 http://web.archive.org/web/20141119130736/http://www.microsoft.com/en-us/download/confirmation.aspx?id=23654
  • Download Northwind database https://supportcenter.devexpress.com/ticket/details/t318781/download-northwind-database
    • Northwind.zip: "Northwind.mdf" - for using with Visual Studio 2012 or later; "Northwind2010.mdf" - for using with Visual Studio 2010. https://supportcenter.devexpress.com/attachment/file/0515055d-97f7-11e5-80bf-00155d62480c
  • sql - Where can I download the Northwind sample database for SQLite? - Stack Overflow https://stackoverflow.com/questions/58458761/where-can-i-download-the-northwind-sample-database-for-sqlite
  • Get the sample SQL Server databases for ADO.NET code samples - ADO.NET | Microsoft Docs https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
  • SQLProvider/Northwind.MDB at master · fsprojects/SQLProvider · GitHub https://github.com/fsprojects/SQLProvider/blob/master/docs/files/msaccess/Northwind.MDB
  • Download Microsoft® SQL Server® 2016 Service Pack 2 Express from Official Microsoft Download Center https://www.microsoft.com/en-US/download/details.aspx?id=56840
    • SQLServer2016-SSEI-Expr.exe https://download.microsoft.com/download/3/7/6/3767D272-76A1-4F31-8849-260BD37924E4/SQLServer2016-SSEI-Expr.exe
  • Offline Installer SQL Server 2016 Express - Microsoft Tech Community  https://techcommunity.microsoft.com/t5/sql-server/offline-installer-sql-server-2016-express/m-p/73267
    • SQLEXPR_x64_ENU.exe    https://download.microsoft.com/download/9/0/7/907AD35F-9F9C-43A5-9789-52470555DB90/ENU/SQLEXPR_x64_ENU.exe
    • SQLEXPRADV_x64_ENU.exe    https://download.microsoft.com/download/9/0/7/907AD35F-9F9C-43A5-9789-52470555DB90/ENU/SQLEXPRADV_x64_ENU.exe
  • Microsoft® SQL Server® 2014 Service Pack 2 (SP2) Express
    ENU\x64\SqlLocalDB.msihttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/ENU/x64/SqlLocalDB.msi ENU\x86\SqlLocalDB.msihttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/ENU/x86/SqlLocalDB.msi SQLEXPR_x64_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPR_x64_ENU.exe SQLEXPR_x86_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPR_x86_ENU.exe SQLEXPR32_x86_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPR32_x86_ENU.exe SQLEXPRADV_x64_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPRADV_x64_ENU.exe SQLEXPRADV_x86_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPRADV_x86_ENU.exe SQLEXPRWT_x64_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPRWT_x64_ENU.exe SQLEXPRWT_x86_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLEXPRWT_x86_ENU.exe SQLManagementStudio_x64_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x64_ENU.exe SQLManagementStudio_x86_ENU.exehttps://download.microsoft.com/download/2/A/5/2A5260C3-4143-47D8-9823-E91BB0121F94/SQLManagementStudio_x86_ENU.exe
  • Microsoft® SQL Server® 2008 R2 SP2 - Express Edition https://www.microsoft.com/en-us/download/details.aspx?id=30438
    SQLEXPR_x86_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPR_x86_ENU.exe SQLEXPR_x64_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPR_x64_ENU.exe SQLEXPR32_x86_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPR32_x86_ENU.exe SQLEXPRADV_x64_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRADV_x64_ENU.exe SQLEXPRADV_x86_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRADV_x86_ENU.exe SQLEXPRWT_x64_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRWT_x64_ENU.exe SQLEXPRWT_x86_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLEXPRWT_x86_ENU.exe SQLManagementStudio_x64_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLManagementStudio_x64_ENU.exe SQLManagementStudio_x86_ENU.exehttps://download.microsoft.com/download/0/4/B/04BE03CD-EAF3-4797-9D8D-2E08E316C998/SQLManagementStudio_x86_ENU.exe>
  • Visual Studio 2005 Retired documentation  https://www.microsoft.com/en-us/download/details.aspx?id=55984
    VS2005_CPP_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_CPP_en-us.pdf VS2005_CSharp_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_CSharp_en-us.pdf VS2005_DeviceDev_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_DeviceDev_en-us.pdf VS2005_General_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_General_en-us.pdf VS2005_JScript_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_JScript_en-us.pdf VS2005_JSharp_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_JSharp_en-us.pdf VS2005_SDK_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_SDK_en-us.pdf VS2005_VB_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_VB_en-us.pdf VS2005_VSTO_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_VSTO_en-us.pdf VS2005_VWD_en-us.pdfhttps://download.microsoft.com/download/1/6/D/16D24ADA-5317-4DE1-B2B2-890B51813D6E/VS2005_VWD_en-us.pdf
  • Previous releases of SQL Server Data Tools (SSDT and SSDT-BI)  https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi?view=sql-server-ver15
    Download SSDT for Visual Studio 2017, SSDT-Setup-ENU.exe(15.8)https://download.microsoft.com/download/5/7/a/57a7de88-9b76-4993-8538-28baebff6518/SSDT-Setup-ENU.exe Download SSDT for Visual Studio 2015, SSDT_14.0.61712.50_1033.ISO (17.4)https://download.microsoft.com/download/f/b/2/fb2d777e-e012-4cde-9900-755acfb8f15a/SSDT_14.0.61712.50_1033.ISO Download SSDT for Visual Studio 2013, SSDT_12.0.61021.0_EN.iso (16.5)https://download.microsoft.com/download/0/C/B/0CB86DAE-EE04-466D-991C-38044814584F/Dev12ISO/SSDT_12.0.61021.0_EN.iso Download SSDT for Visual Studio 2012, SSDT_11.0.50730.0_EN.iso (11.1.50727.1)https://download.microsoft.com/download/6/0/9/6093E282-8C3A-45D4-A3BE-6B8109284791/Dev11Iso/SSDT_11.0.50730.0_EN.iso

SQL and ASP.NET

  • How to Get Started with SQL Server and .NET https://www.mssqltips.com/sqlservertip/5677/how-to-get-started-with-sql-server-and-net/
  • SQL Server connector https://trino.io/docs/current/connector/sqlserver.html
  • Connect to MS SQL server | JetBrains Rider https://www.jetbrains.com/help/rider/DB_Tutorial_Connecting_to_MS_SQL_server.html
  • ASP.NET 4.0 has not been registered on the Web server. You need to manually configure your Web server https://www.aspsnippets.com/Articles/ASPNET-40-has-not-been-registered-on-the-Web-server-You-need-to-manually-configure-your-Web-server.aspx
  • ASP.NET Side-by-Side Overview | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/a99txfy5(v=vs.100)?redirectedfrom=MSDN
  • How to: Host Web Applications That Use Different Versions of the .NET Framework on the Same Server | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/dd329554(v=vs.100)?redirectedfrom=MSDN
  • How to: Upgrade an ASP.NET Web Application to ASP.NET 4 | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/dd483478(v=vs.140)?f1url=%3FappId%3DDev11IDEF1%26l%3DEN-US%26k%3Dk(vwd.ConfigureAspNetForIIS)%26rd%3Dtrue
  • How To Connect SQL Database In ASP.NET Using C# And Insert And View The Data Using Visual Studio 2015 https://www.c-sharpcorner.com/article/how-to-connect-sql-database-in-asp-net-using-c-sharp-and-insert-and-view-the-data-usi/
  • How to connect my site to SQL Express ? | The ASP.NET Forums https://forums.asp.net/t/2122781.aspx?How+to+connect+my+site+to+SQL+Express+
  • sql server 2008 - How to use aspnet_regsql.exe - Stack Overflow  https://stackoverflow.com/questions/14733329/how-to-use-aspnet-regsql-exe
  • Creating the Application Services Database for SQL Server | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/x28wfk74(v=vs.100)
  • Accessing SQL Server from a Web Application | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/ht43wsex(v=vs.100)
  • How to: Access SQL Server Using Windows Integrated Security | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/bsz5788z(v=vs.100)
  • Creating and Configuring the Application Services Database for SQL Server | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/2fx93s7w(v=vs.100)
  • Using SQL Server Express with ASP.NET | Microsoft Docs https://docs.microsoft.com/en-us/previous-versions/aspnet/ms247257(v=vs.100)
  • Building applications with OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Docs  https://docs.microsoft.com/en-us/sql/connect/oledb/applications/building-applications-with-oledb-driver-for-sql-server?view=sql-server-ver15
  • Using Connection String Keywords with OLE DB Driver - OLE DB Driver for SQL Server | Microsoft Docs   https://docs.microsoft.com/en-us/sql/connect/oledb/applications/using-connection-string-keywords-with-oledb-driver-for-sql-server?view=sql-server-ver15
  • UNICOM Intelligence  https://support.unicomsi.com/manuals/intelligence/751/index.html#page/DDL%2FAvailableDSCs.31.108.html%23
  • The connection name 'constr' was not found in the applications configuration or the connection string is empty  https://www.aspsnippets.com/Articles/The-connection-name-constr-was-not-found-in-the-applications-configuration-or-the-connection-string-is-empty.aspx

ASP.NET, SQL, and Web.Config

  • Open SQL Server database by using SQL Server .NET Data Provider with Visual Basic .NET https://docs.microsoft.com/en-us/troubleshoot/dotnet/framework/open-database-by-sql-server-dotnet-data-provider
  • sql connection using vb.net  https://www.codeproject.com/Questions/170218/sql-connection-using-vb-net
  • asp.net (web forms with VB.Net) connecting to a sql database https://stackoverflow.com/questions/4991856/asp-net-web-forms-with-vb-net-connecting-to-a-sql-database
  • How do I create a Northwind db connection string ? https://social.msdn.microsoft.com/Forums/sharepoint/en-US/fbad546f-c680-406b-855d-c807feae3429/how-do-i-create-a-northwind-db-connection-string-?forum=Vsexpressvcs
  • Store Connection String in Web.config - ConnectionStrings.com https://www.connectionstrings.com/store-connection-string-in-webconfig/

©sideway

ID: 211000005 Last Updated: 10/5/2021 Revision: 0 Ref:

close

References

  1. Active Server Pages,  , http://msdn.microsoft.com/en-us/library/aa286483.aspx
  2. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
  3. ASP Best Practices,  , http://technet.microsoft.com/en-us/library/cc939157.aspx
  4. ASP Built-in Objects,  , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
  5. Response Object,  , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
  6. Request Object,  , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
  7. Server Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
  8. Application Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
  9. Session Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
  10. ASPError Object,  , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
  11. ObjectContext Object (IIS),  , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
  12. Debugging Global.asa Files,  , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
  13. How to: Debug Global.asa files,  , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
  14. Calling COM Components from ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
  15. IIS ASP Scripting Reference,  , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
  16. ASP Keywords,  , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
  17. Creating Simple ASP Pages,  , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
  18. Including Files in ASP Applications,  , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
  19. ASP Overview,  , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
  20. FileSystemObject Object,  , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
  21. http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx,  , ADO Object Model
  22. ADO Fundamentals,  , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx
close

Latest Updated LinksValid XHTML 1.0 Transitional Valid CSS!Nu Html Checker Firefox53 Chromena IExplorerna
IMAGE

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 8

Culture

Chinese 1097

English 339

Reference 79

Computer

Hardware 224

Software

Application 213

Digitization 32

Latex 52

Manim 204

KB 1

Numeric 19

Programming

Web 289

Unicode 504

HTML 66

CSS 65

SVG 46

ASP.NET 270

OS 429

DeskTop 7

Python 72

Knowledge

Mathematics

Formulas 8

Algebra 84

Number Theory 206

Trigonometry 31

Geometry 33

Coordinate Geometry 2

Calculus 67

Complex Analysis 21

Engineering

Tables 8

Mechanical

Mechanics 1

Rigid Bodies

Statics 92

Dynamics 37

Fluid 5

Fluid Kinematics 5

Control

Process Control 1

Acoustics 19

FiniteElement 2

Natural Sciences

Matter 1

Electric 27

Biology 1

Geography 1


Copyright © 2000-2022 Sideway . All rights reserved Disclaimers last modified on 06 September 2019