How to use CommandBuilder class in .NET

Question

Hi What is use of commandbuilder class in .net. How will use sqlcommandbuilder class in my application. Plz help me. Thanks.

Suthish Nair · Answer

PR the link you posted is same..

Javeed M Shaikh · Answer

Hi Alok The SQLCommandBuilder generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. Following is the simple example: using (SqlConnection connection = new SqlConnection(connectionString)) { SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand(queryString connection); SqlCommandBuilder builder = new SqlCommandBuilder(adapter); connection.Open(); DataSet dataSet = new DataSet(); adapter.Fill(dataSet tableName); //code to modify data in DataSet here builder.GetUpdateCommand(); //Without the SqlCommandBuilder this line would fail adapter.Update(dataSet tableName); return dataSet; } Please do not forget to mark Accepted Solution

Prabhu Raja · Answer

Hi You can get more about CommandBuilder class in .NET by reading the following Article written by mahesh sir http://www.c-sharpcorner.com/UploadFile/mahesh/170/

Suthish Nair · Answer

refer article: CommandBuilder in ADO.NET