Email: Password:       Forgot Password 
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
Difference between SqlCommand and SqlCommandBuilder

Posted On: 07/12/2012 07:40:55
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.
Posted On: 07/12/2012 07:41:35
sqlcommand is used to execute query whereas commandbuilder we cannot type the full querye like update,insert it will automatically take the query..
Posted On: 07/12/2012 07:42:08
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.
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us