Poornima is absolutely right , sqlcommand is used to fire scaler or non query kind of data where , sqlcommandbuilder used for CRUD kind of query somewhat time

SQLCommand is used to execute all kind of SQL queries (DML & DDL). However, SQLCommandBuilder object is used to build & execute SQL (DML) queries like select, insert, update & delete.