You write only select command to retrieve data form database with the help of DataReader and rest of the commands(Like Insert , Update and Delete) are automatically generated when you create the instance of CommandBuilder .
SqlCommandbuilder is mostly use for execute the query against the database for CRUD application.
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.