Watching:

Basic Web Form and Connecting to Database SQL Server


show more Creating a basic web form and connecting to a database provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions show less
please wait ...

Creating a basic web form and connecting to a database

The next thing we'd like to do is create a connection between our web application and our database. We'll do this, off of a window called Database Explorer. Inside of Database Explorer the top option is Data Connections. We can right click that and say Add Connection. Up here you'll need to give it the name of your SQL Server, or the IP address. There's mine. We have the option to use Windows authentication or SQL authentication. I'm going to stick with Windows and we'll need to choose which database we're interested in.

My database that we were working on in previous examples. Hit Test Connection. It says Succeeded and that's good. And now we see a new connection named Thusly, basically it's the name of our server.name of the database. going to open that up and explore it, we see the tables we were working with previously, and we also see the store procedures we worked with previously, and the functions we worked with previously. So we are very close to being able to r...

Creating a basic web form and connecting to a database
Video duration: 2m 57s 1h 52m Advanced

Viewers:

Creating a basic web form and connecting to a database provides you with in-depth training on Business. Taught by Martin Guidry as part of the SQL Server: Triggers, Stored Procedures, and Functions

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...