Interview Questions on ADO.NET

Interview questions on ADO.NET Page 2

<< PREV
11. When do you use ExecuteReader method?
Use ExecuteReader when the sql command or stored procedure that is being executed returns a set of rows.
12. When do you use ExecuteNonQuery method?
If the command or stored procedure performs INSERT, DELETE or UPDATE operations, then we use ExecuteNonQuery method. ExecuteNonQuery method returns an integer specifying the number of rows inserted, deleted or updated.
13. When do you use ExecuteScalar method?
Use ExecuteScalar, when a sql command or sp that is being executed return single value.
<< PREV