What are the methods provided by command object
| There are the different method are provided by command objects.
(1)ExecuteNonQuery:-This methods executes the commandtext property which is passed with the connection object and this does not return any rows.It will used for UPDATE,INSERT or DELETE.Its return the integer value. (2)ExecuteReader:-Its execute the command text.But its return reader object that is read only. (3)ExecuteScalar:-Its execute the command text but this return on |
|
| ly single value only the first value of first column. And any other returned column return are discarded.This is fast and efficent for singleton value . | |