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 the different levels Of IIS isolation?  The IIS consist of 3 level of isolation as shown below:- LOW (IIS process):- In this type of isolation the main IIS proc

What is a runtime engine? A runtime engine of WF gives the basic functionality to execute and manage the workflow lifetime. It runs within the host process and is responsible f

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Some of major differences between a stored procedure and user defined are as follows:-

Project Description: I need a SharePoint Developer tutor to teach me the development of SharePoint from scratch. We will be communicating through TeamViewer and Skype. I have ac

Prepare datamodel, API and more Project Description: Dear all, we would like you to prepare database and an API which can be used in the shopping cart (checkout and delivery

How do you implement prototype pattern in .NET? The Cloning is achieved by using the ICloneable of the System namespace. It has a "Clone" method that actually returns the refer

System Simulation - repost 2 Project Description: A. Prepare random numbers of the form: Case 1: Uniformly distributed random numbers (RNs) [range: 0.0-1.0] Case 2: Exp

upload files using file upload control to google drive

I am looking individuals who have company experience working on Jquery and Microsoft Technology ( MVC 4.5 ), who will take live online session and provide training through Team Vie

Describe session handling in a web farm, how does it work and what are the limits ?    In ASP.NET there are three ways to manage session objects. One support the in-proc mechani