SqlCommand and SqlCommandBuilder


  • SQLCommand is used to execute all kind of SQL queries like DML(Insert, update,Delete) & DDL like(Create table, drop table etc) 
  • SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.