Join Martin Guidry for an in-depth discussion in this video Creating a basic web form and connecting to a database, part of SQL Server: Triggers, Stored Procedures, and Functions.
…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…run these store procedures off of the web page.…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.