What are basic methods of Dataadapter?

Answer

The most commonly used methods of the DataAdapter are:

Fill:

This method executes the SelectCommand to fill the DataSet object with data from the data source.
Depending on whether there is a primary key in the DataSet, the ‘fill’ can also be used to update an existing table in a DataSet with changes made to the data in the original datasource.

FillSchema

This method executes the SelectCommand to extract the schema of a table from the data source.
It creates an empty table in the DataSet object with all the corresponding constraints.

Update

This method executes the InsertCommand, UpdateCommand, or DeleteCommand to update the original data source with the changes made to the content of the DataSet.

Methods of Dataadapter in ADO.NET - June 06, 2009 at 10:30 AM by Shuchi Gauri

Explain the basic methods of Dataadapter

Some basic methods of dataadpater are:

a. Fill: adds or updates the rows to dataset from the datasource
b. FillSchema: adds a datatable with the sameschema as in the datasource
c. Update: it calls insert, update, delete sql commands for transferring all the changes from the dataset to the datasource
d. Dispose : releases all the resources

All ado.net Questions

Ask your interview questions on ado-net

Write Your comment or Questions if you want the answers on ado-net from ado-net Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---