What are the methods available in SqlCommand object??

ExecuteScalar()---> Executes 'select' statement which will returns  data in the form of rows and columns.

ExecuteScalar()--> Executes a 'select' statement which will returns single value.

ExecuteNonquery()-->Executes the DML(Data manipulation) statements and returns how many records get effected.

ExecuteXMLReader()--> Executes 'select' statement and returns data in the format of xml

System.Xml.XmlReader xmlr = cmd.ExecuteXmlReader();