SqlCommand Methods

ExecuteNonQuery

• Overridden. Executes a Transact-SQL statement against the connection and returns the number of rows affected.

ExecuteReader

• Overloaded. Sends the CommandText to the Connection and builds a SqlDataReader.

ExecuteScalar

• Overridden. Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

ExecuteXmlReader

• Sends the CommandText to the Connection and builds an XmlReader object.