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
IMAGE

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 8

Culture

Chinese 1097

English 337

Reference 68

Computer

Hardware 154

Software

Application 207

Digitization 25

Latex 35

Manim 203

Numeric 19

Programming

Web 285

Unicode 504

HTML 65

CSS 63

SVG 9

ASP.NET 240

OS 422

DeskTop 7

Python 64

Knowledge

Mathematics

Formulas 8

Algebra 84

Number Theory 206

Trigonometry 31

Geometry 32

Coordinate Geometry 1

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-2021 Sideway . All rights reserved Disclaimers last modified on 06 September 2019