DOT NET Tutorial
Added to favorite list
Updated On 02 Feb, 19
4.1 ( 11 )
In this video we will learn on how to work with database.
Here we will learn how to use Managed Provider for SQL Server and will also discuss all the important objects like SqlConnection, SqlCommand and SqlDataReader.
a) Introduction to SQL.
b) Evolution of ADO.NET after Native Drivers, ODBC Drivers, DAORDO
c) About Managed Providers
d) Important Objects in Managed Provider
a) Creating Database using VS.NET
b) Establishing Connection with Database
c) Connection String Formats
a) Executing simple Insert, Update and Delete Statements
b) Executing Select Statement and using SqlDataReader
a) Prepared Statements
b) Stored Procedures
a) Managing Transactions
b) Asynchronous Execution of Sql Statements
c) To write provider independent code
Sep 12, 2018
Excellent course helped me understand topic that i couldn't while attendinfg my college.
March 29, 2019
Great course. Thank you very much.