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 lazy initialization? Lazy initialization is a process by which an object is not initialized until it is first called in your code. The .NET 4.0 introduces a new wrapper

What is XML DOM? The DOM stands for Document Object Model, which explains the logical formation of documents and provides the way to access and manipulate a document. It suppli

The ASP.NET provides two namespaces. The first is System.WEB.mailmessage class and the second is System.Web.Mail.Smtpmail class.

What are the differences between ASP and ASP .Net ?  ASP: Code is Interpreted ASP.NET: Code is Compiled   ASP: Business Logic and Presentation Logic are in a one

Counting Number of Words in a String - C# Program Anyone can suggest me the output of the following program. using System;   class CountWords { public static void

How inheritance is achieved in VB.NET? The Inheritance is achieved by using "Inherits" keyword in the VB.NET (& For C# it is ":"). Easy Sample is provided in CD for understandi

NopCommerce v3.10 - Content Page Creation, Product Import and Site Customization Project Description: I have an existing website with about 800 products and we could like to

Describe the rules and regulations that must be followed whereas creating a well-formed XML document. The following are the rules and regulations that are essential to follow w

What are resource files? The Resource files are the files which contain program resources. Many programmers think that resource files are used only for storing strings. But you

Accepting a List of 5 Items - C# Program Hello, I've been trying so many codes for this but those codes didn't work well. Please write the code for Accepting a List of 5 Items