What is the use of the CommandBuilder class?

The CommandBuilder class is used to automatically update a database according to the changes made in a DataSet.

This class automatically registers itself as an event listener to the RowUpdating event. Whenever data inside a row alters, the object of the CommandBuilder class automatically produces an SQL statement and uses the SelectCommand property to commit the changes made in DataSet.

OLEDB provider in .NET Framework has the OleDbCommandBuiider class; while, the SQL provider has the SqlCommandBuilder class.

 

Posted Date: 7/4/2013 1:53:13 AM | Location : United States

Ask an Expert

Related Discussions:- What is the use of the commandbuilder class, Assignment Help, Ask Question on What is the use of the commandbuilder class, Get Answer, Expert's Help, What is the use of the commandbuilder class Discussions

Write discussion on What is the use of the commandbuilder class
Your posts are moderated

Write your message here..

Related Questions

What are runtime services, What are runtime services? Runtime services ... What are runtime services? Runtime services having of predefined and user-defined classes that are available to the workflow runtime engine during implementation to customize t

Different locks in sql server, What are the different locks in SQL SERVER? ... What are the different locks in SQL SERVER? Depending on the transaction level there are six types of lock that can be acquired on data :- 1)Intent: The intent lock des

Difference between delete table and truncate table commands, What is the di... What is the difference between DELETE TABLE and TRUNCATE TABLE commands? Following are differences between delete & truncate commands:- 1)The DELETE TABLE syntax logs the de

System simulation, System Simulation - repost 2 Project Description: ... 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

Whatsapp bulk messaging, Project Description: We require working system ... Project Description: We require working system to send message in bulk to whats-app numbers without getting blocked. Multiple senders can be used. Skills required: .NET, P

Calculation of employee payment, how we calculate net pay of employee how we calculate net pay of employee

Answer, #queWrite a XML with database with book details (BOOK ID, Title, Au... #queWrite a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)stion..

What is .net framework, C# Programming 1. What is .Net Framework? 2.... C# Programming 1. What is .Net Framework? 2. Write short notes on constructors and destructors. 3. Explain boxing and unboxing with examples. 4. What is a mixed mode a

Is .net is compile time or runtime environment, .NET is Compile Time OR Run... .NET is Compile Time OR RunTime Environment?   .Net's framework has CLS,CTS and CLR.CTS checks declaration of types at the time when u write code and CLS defines some rules and

Set up a ftp file server and active ftp file transfer, Set up a FTP File Se... Set up a FTP File Server and active FTP File Transfer using VB.NET The Job Description is as given: 1. Manually set up a FTP file server on a remote server. 2. Manually ad