Last post Jul 08, 2016 05:37 AM by Angie xu - MSFT
Jul 07, 2016 10:03 AM|robby32|LINK
Is there a step y step example that i can follow that show how i can query a sql database to extract data and present on a web form.
usually an access database with extension .mdb is put in the app_data directory in the Visual Studio project , but i would like to use sql database that i can populate instead.
Do i create the database in sql server express ?
Also I would like to use the project on different machines so does that mean the sql server connection needs to be generic ?
Jul 08, 2016 05:37 AM|Angie xu - MSFT|LINK
To work with data in Web Form, you can get started
This topic provides examples of SQL Server connection strings for typical ASP.NET web application scenarios. It also includes instructions for converting connection strings between
SQL Server Express and LocalDB, and explanations of some common connection string settings.