There are different methods under SqlCommand and they are :
Cancel – Cancel the query
CreateParameter – returns SQL Parameter
ExecuteNonQuery – Executes and returns number of rows affected
ExecuteReader – executes and returns data in DataReader
ExecuteScalar – Executes and returns single value
ExecuteXmlReader – Executes and return data in XMLDataReader object
ResetCommandTimeout – Reset Timeout property
