When do you use ExecuteReader, ExecuteNonQuery, ExecuteScalar methods?

Post

View All

Partap Tanwar

When do you use ExecuteReader, ExecuteNonQuery, ExecuteScalar methods?

By Partap Tanwar in ADO.NET on Sep 10 2009

0
9.2k
1

Post Your Answer

Sep, 2009 12
ExecuteReader :- used for DDL queries and return a dataTable.used for SELECT queries and return the result in DataTable.

ExecuteNonQuery:- Used for DML queries and return the no of row affected in integer
Used for Insert, update and delete qeries.

ExecuteScalar:- Used for executing Stored procedures.

thanks
http://yuvadeveloper.blogspot.com
- 0