.Net database

Question

Which method of command object doesn't return any row?

Rajeesh Menoth · Answer

Hi Answer is : ExecuteNonQuery 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 ..!!

Yugandhara Joshi · Answer

Thank you...

Jignesh Trivedi · Answer

ExecuteReader method od SqlCommand class return rows. excep this method all method return scalar value. hope this will help you

Upendra Pratap Shahi · Answer

ExecuteNonQuery:-This method executes the command specifies and returns the number of rows affected