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.

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

Using SqlCommandBulider we can generate Select update delete Querys

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.

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.

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.

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)