Difference between SqlCommand and SqlDataAdapter?

[deepsaha2008]

.You use the SqlDataAdapter to fill datasets. You use the SqlCommand To get datareaders, Execute non query sql statements (insert,update,delete). The SqlDataAdapter uses SqlCommand objects to fill datasets. In fact one of the constructors for the sqlDataAdapter is an sqlCommand.