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 are Value types and Reference types The Value types directly contain their data which are either allocated on the stack or allocated in-  Line in a  structure. The Refe

The Events are always public as they are meant to serve each one registering to it. But you can access modifiers in the events.You may have events with protected keyword which will

Question: (a) List and describe the four parameters contained in the second section of the AdRotator Scheduler File. (b) Distinguish between the following types of "Locks"

Add in bitcoin payment option in website Project Description: Include bitcoin files to magento for payment options on website. It is just including the files to the magent

What is the difference between System exceptions and Application exceptions? All exception is derived from Exception Base class. Exceptions are generated programmatically or ca

I need Isometric Exploration Tablet Game I am endeavoring to build an 2D tile-based isometric game, primarily for Android and iOS tablet devices. It will be built in Unity 3d v4

Print Pyramids of Numbers - C# Program Hello can you please provide me some examples regarding to the Print Pyramids of Numbers in C#.

What is a class? A class describes all the attributes of objects, as well as the methods that execute the behaviour of member objects. It is a comprehensive data type, which sh

What is an application domain? Previously "PROCESS" were used as the security boundaries. One of the process has its own virtual memory and does not overlap the  another proces

Project Description: Online game development 1. Online Live Baccarat Game is required - server program(IOCP or ect..). - 2D graphic design. - client program. - we