Pankaj Naval

• Jun 8th, 2006

 

SQLCommand is used to retrieve or update the data from database.

You can use the SELECT / INSERT,UPDATE,DELETE command with SQLCommand. SQLCommand will execute these commnds in the database.

SQLBUILDER is used to build the SQL Command like SELECT/ INSERTR, UPDATE etc.

SuryaNarayanan Sk

• Jun 12th, 2006

 

Using Sqlcommand   we can Execute    select,update,delete ..... Querys

Using SqlCommandBulider we can  generate Select ,update,delete Querys

 

Mob: +91 9849255958

• Jan 4th, 2007

 

SqlCommand  is used to execute any sql statement, where as

SqlCommandBuilder generates sql commands like INSERT, UPDATE, and DELETE based on the columns in the SELECT statement.

vishal_upadhayay

 Profile Answers by vishal_upadhayay 

• Jan 22nd, 2007

 

SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.

Whereas

SQLCommand  is used to execute all kind of SQL queries like DML & DDL.

sahu

 Profile Answers by sahu Questions by sahu

• Mar 29th, 2007

 

Hi All,

Ans:

a) SQLCommand  is used to execute all kind of SQL queries like DML(Insert,  update,Delete) & DDL like(Create table, drop table etc)


b)SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.

Goblet

 Profile Answers by Goblet 

• Aug 31st, 2009

 

SqlCommandBuilder is used to generate sql statements in order to update a dataset with more efficiently.
We have just to specify the table when you use the Fill method

Example :
       
Dim builder As SqlCommandBuilder = New SqlCommandBuilder(adapter)

adapter.Fill(dataSet, tableName)

//doesn't work if you don't specify previously  the SQLCommandBuilder
adapter.Update(dataSet, tableName)

abhi_la2006

 Profile Answers by abhi_la2006 

• Sep 20th, 2010

 

SQL command excute and handle both DML(Insert, Update, Delete) and DDL (Drop Create Table db) While sqlcommandbuilder excute only DML queries.

abhi_la2006

 Profile Answers by abhi_la2006 

• Jul 13th, 2011

 

Sql command use to only execute dml like update delete insert but sql command builder use the dml as well as the ddl like create database alter etc.

Lijo

• Nov 10th, 2011

 

SqlCommand:

SqlCommand is used to execute Query involving Select, Update, Delete operation and to Execute SQL Stored procedures

SqlCommandBuilder:

SqlCommandBuilder provides the feature of reflecting the changes made to a DataSet or an instance of the SQL server data. When an instance of the SqlCommandBuilder class is created, it automatically generates Transact-SQL statements for the single table updates that occur. The object of the SqlCommandBuilder acts as a listener for RowUpdating events, whenever the DataAdapter property is set.

Code
DataSet ds = new DataSet();


SqlConnection cn = new SqlConnection("strSomeConnectionString");


//Autogenerate Insert, Update & Delete commands


SqlDataAdapter da = new SqlDataAdapter("Select from t_Something", cn);


SqlCommandBuilder scb = new SqlCommand(da);