.Net database

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

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.

 

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

 

The answer is helpful.Then please accept it..!!