ADO.Net Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 394 Page Views: 

How do use CommandBuilder class?



Posted By: Avi Date: 14 October 2010 11:17:47 AM
 Answer:

CommandBuilder objects generates INSERT, UPDATE, DELETE statements for a DataTable based on Select query. You create CommandBuilder with data adapter object with filled Select Command. After that you can call GetUpdatedCommand(), GetDeleteCommand()


Posted By: avibtech


Date: 14 October 2010 11:17:47 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image Z8pXmf
Related Questions
ADO.Net : What is the purpose of DataContext objects?

What is the purpose of DataContext objects?

DataContext is entry point for the LINQ to SQL
Category: ADO.Net Date: 10/14/2010 8:30:47 AM
ADO.Net : Does ADO.NET supports asynchronous execution?

Does ADO.NET supports asynchronous execution?

yes
Category: ADO.Net Date: 10/14/2010 7:48:48 AM
ADO.Net : How do you reject changes made to data set?

How do you reject changes made to data set?

by calling RejectChanges method
Category: ADO.Net Date: 10/14/2010 5:53:47 AM
ADO.Net : Is it possible to use single code to work with different data providers?

Is it possible to use single code to work with different data providers?

Yes. By using IDbConnection, IDbCommand(you can create command object using IDbConnection.CreateComm....
Category: ADO.Net Date: 10/14/2010 5:01:48 AM
ADO.Net : How do you check number of rows affected by update query?

How do you check number of rows affected by update query?

ExecuteNonQuery Method on SqlCommand returns number of rows affected.
Category: ADO.Net Date: 10/14/2010 5:01:48 AM