- ExecuteReader : Use for accessing data. It provide a forward-only, read-only, connected recordset.
- ExecuteNonQuery : Use for data manipulation, such as Insert, Update, Delete.
- ExecuteScalar : Use for retrieving 1 row 1 col. value.,i.e, Single value. eg: for retrieving aggregate funtion. It is faster than other ways of retrieving a single value from DB
Saturday, February 13, 2010
What is Difference between ExecuteReader, ExecuteNonQuery and ExecuteScalar
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.