We learned about T-SQL and the benefits from using T-SQL. We used the Sql Server Management Studio (SSMS) to generate Stored-Procedures. then we executed the stored procedures from within the SSMS and from C# code. we generated store-procedures with parameters and without parameters. later on, we created a Winform application and used ADO.NET to create a GridView and ComboBox which retrieves data from the MSSQL automatically using queries and stored-procedures.
More topics covered:
- Stored-procedures location in SSMS
- Stored-procedures execution in SSMS designer
- C# ADO.NET using code and wizard
- Retrieving data from MSSQL into ListBox
Links:
- T-SQL database.guide
- T-SQL Procedural programming
- Create Procedures – MSDN link
- ADO.NET overview – MSDN link
- Create stored-procedure query
- Create stored-procedure with parameter query
- Calling stored procedure in query
- Calling stored procedure with parameter in query
- C# – calling stored procedure
- C# – calling stored procedure with parameter
- ADO.NET – ComboBox connection to query result
- SQL vendors supporting stored-procedures
- Advantages of using stored-procedures
- Lesson Summary Video!
- Homework project!
.NET Experts 