What is ADO.Net?
ADO.NET is an object-oriented set of libraries that allows you to interact with data sources. Commonly, the data source is a database, but it could also be a text file, an Excel spreadsheet, or an XML file. For the purposes of this tutorial, we will look at ADO.NET as a way to interact with a data base.
As you are probably aware, there are many different types of databases available. For example, there is Microsoft SQL Server, Microsoft Access, Oracle, Borland Interbase, and IBM DB2, just to name a few. To further refine the scope of this tutorial, all of the examples will use SQL Server.
CURRICULUM
- 1.1 What is ADO.Net
- 1.2 History of ADO.Net
- 1.3 Difference between ADO and ADO.NET
- 1.4 Providers
- 1.5 Connected and disconnected architecture
- 2.1 The SQLDataConnection object
- 2.2 The SQLCommand object
- 2.3. The DataSet object
- 2.3. The SQLDataReader object
- 2.3. The DataAdapter object
- 3.1 Creating tables in dataset
- 3.2 Data column
- 3.3 Data Raw
- 3.4 Data Table
- 3.5 Updating, inserting and modification in data table
- 3.6 Saving changes into data base using command builder
- 3.7 Working with command and connection
- 4.1 Execute command with command object
- 4.2 Implementation and difference of execute non query and execute scalar
- 4.3 Executing stored procedure
-
4.4 Creating parameter and SQL injection
- 6.1 Raw Filter
- 6.2 Sorting
- 6.3 Update, insert, delete via Dataview
