Ashish Kumar Singh
Explain the use of ExecuteNonQuery, ExecuteReader, ExecuteScalar?
Posted by Ashish Kumar Singh in ASP.NET Programming on Oct 01, 2012
  • 0
  • 4
  • 11411
Do you know the answer for this question? Post it below.
Guest
Posted by kiran kumar on Feb 04, 2013
  • 0

These are the methods under Command Object
ExecuteReader : Used to execute SQL Select Command
ExecuteScalar : Used to execute SQL Select command which is used to return a single value. Example the group function output
ExecuteNonQuery : USed to execute SQL Insert, Delete and Update Commands.

Posted by Vithal Wadje on Oct 05, 2012
  • 0

ExecuteScalar--

ExecuteScalar returns only one value after execution of the query . it returns the first field in the first row. it is faster and convinient way when you wants rerive only single value at a time.



Posted by Vithal Wadje on Oct 05, 2012
  • 0

ExecuteReader-

this method returns a DataReader which is filled with the data that is retrived using the coommand object . this is known as a forward only retrival of records.




Posted by Vithal Wadje on Oct 05, 2012
  • 0

ExecuteNonQuery-



ExecuteNonQuery does not return any data at all. it is used basically to insert update operationas on table. means it is used for execution of DML commands



e.g



sqlcommand cmd=new sqlCommand("insert into emp values ('1','2'",con);

con.open();

cmd.ExecuteNonquery();






Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS