SqlCommand Methods

Posted by dragon on Saturday, 10 September 2011

type='html'>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.

{ 0 comments... read them below or add one }

Post a Comment