How is Dataadapter useful in ADO.NET?

Dataadapters are used to connect Dataset object to a set of command objects.

• To fetch data from the database and display them in the datatables of dataset. This is achieved using Fill method of dataadapter.
• To fetch data from dataset and update them in necessary tables of database. This is achieved using Update method of dataadapter.

There are four different types of Dataadapters. Their purpose and usage is mentioned below:

• OleDbDataAdapter: Dataadapters used to interact with databases through OLE DB provider. It belongs to System.Data.OleDb namespace.
• SqlDataAdapter: Dataadapters used to interact with SQL Server database with version 7.0 or higher through Tabular data services. It belongs to System.Data.SqlClient namespace.
• OdbcDataAdapter: Dataadapters used to interact with databases exposed by an ODBC provider. It belongs to System.Data.Odbc namespace.
• OracleDataAdapter: Dataadapters used to interact with Oracle database. It belongs to System.Data.OracleClient namespace.

Dataadapter has four different properties which controls database updates. The properties are SelectCommand, UpdateCommand, InsertCommand and DeleteCommand. These commands are used to read, update, add and delete records from a database respectively.

| How do you implement Observer Design Pattern in .NET? | How do you pass data between different Tiers in .NET Architecture? | How is Classic ADO different from ADO.NET? | How is Dataadapter useful in ADO.NET? | How is Datareader different from Dataset in ADO.NET? | How is .NET Application Development different from Traditional Development? | How is HashTable different from ArrayList in .NET? | How is Inheritance achieved in C#? | How is new keyword different from override keyword during inheritance in .NET? | How is String class different from StringBuilder class in .NET? | Illustrate ADO.NET Architecture | Illustrate the importance of Server.Transfer and Response.Redirect in .NET? | Mention the different objects available in Dataset of ADO.NET | Mention the usage of Connection Object in ADO.NET | What are the commonly used methods of Dataadapter in ADO.NET? | What are the different Behavioral Design Patterns that can be used in .NET Architecture? | What are the different Creational Design Patterns that can be used in .NET Architecture? | What are the different Structural Design Patterns that can be used in .NET Architecture? | What are the methods provided by Command Objects in ADO.NET? | What is Internal Access Modifier in C#? |