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

How to use CommandBuilder class in .NET

Answers (4)