Course in dot Net Database Application using ADO.Net full overview
Entry requirements- PC with reasonably good configuration
- Broadband connection (or Internet access using your Company/Organisation network etc.)
- Headphones with microphone.
- Basic knowledge of working with PC and Internet
Course description
This is an ‘Advanced’ level course designed to enable the developers to use the tremendous database manipulation powers of ADO. NET to build effective database applications.
ADO.NET: Developing Database Applications
A Brief History of Universal Data Access
Managed Providers
Connecting to a SQL Server Database
SQL Server Authentication
Connecting to an OLE DB Data Source
Reading Data into a DataSet
Relations Between DataTables in a DataSet
The DataSet's XML Capabilities
Binding a DataSet to a Windows Forms DataGrid
Binding a DataSet to a Web Forms DataGrid
Typed DataSets
Reading Data Using a DataReader
Executing Stored Procedures Through a SqlCommand Object