locked
How can i build a web form that queries a sql database in visual studio ? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1253338400 posted

    Hi,

    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 ?

    Thanks

    Thursday, July 7, 2016 10:03 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-166373564 posted

    Hi,

    To work with data in Web Form, you can get started here.

    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.

    Best regards,

    Angie 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 8, 2016 5:37 AM