Basic methods of data adapter, DOT NET Programming

What are basic methods of Data adapter?

The three most commonly used methods of Dataadapter are as follows:-

1)Fill :- It Executes the SelectCommand to fill the DataSet object with the data from the data source. This can also be used to update (refresh) an existing table in a DataSet with changes made to the data in the original datasource if there is a primary key in the table in the DataSet.

2)FillSchema :-It Uses the SelectCommand to extract the schema for a table from the data source, and generates an empty table in the DataSet object with all  corresponding constraints.

3)Update:- It Calls the respective InsertCommand,DeleteCommand , or  UpdateCommand for every inserted, deleted,or updated  row in the DataSet so as to update the original data source with the changes made to the content of the DataSet. This is few like the UpdateBatch method provided by the ADO Recordset object, but in the DataSet it can be used to update more than one table.

Posted Date: 9/24/2012 2:25:43 AM | Location : United States







Related Discussions:- Basic methods of data adapter, Assignment Help, Ask Question on Basic methods of data adapter, Get Answer, Expert's Help, Basic methods of data adapter Discussions

Write discussion on Basic methods of data adapter
Your posts are moderated
Related Questions

What is the difference between Class and structure's? The main differences between them are as follows:- 1) The Structure is value types while classes are referen

Djvu view and setup,  sourcecode with nice UI Project Description: i want an application build for viewing djvu files -must include setup -must include source code -

What is the use of DISPOSE method? This Dispose method belongs to the IDisposable interface. It is bad  to override the finalize method for writing the cleaning of the unmanage

What is MVC pattern? The main purpose  of using  the MVC pattern is to decouple the GUI from the Data. It also gives the ability to provide multiple views for the same Data. Th

Website update... Immediate need I want someone experienced in ASP.NET who can set up PayPal on my website by Feb. 1st. I would similarly like to have some changes made in the t

I need asp.net print page task Project Description: I have a little task on asp.net, I need to print a text data to receipt printer from web page, I used the subsequent code

Describe the role that XSL can play while dynamically generating HTML pages from a relational database. The SQLXML 3.0 and advanced versions give the facility of mapping the SQ

What is cyclomatic complexity and why is it important? Cyclomatic complexity is a computer science metric (measurement) developed by Thomas McCabe used to generally calculate t

I need to develop a new website. Previous site was not good and I need better one with not only static but using also more details . Skills required: .NET, MySQL, C# Programm