Define different execute methods of ADO.NET Command Object

1.	Define different execute methods of ADO.NET Command Object
Answer» Define different execute METHODS of ADO.NET Command Object Below are the 4 execute methods of ADO.NET Command object (1)ExecuteScalar:- This METHOD returns a single value from the FIRST row and first column of the result get from the execution of SQL QUERY. (2)ExecuteNonQuery:- This method executes the DML SQL query just like insert, delete or update and then returns the NUMBER of rows affected by the action. (3)ExecuteReader:- This method returns DataReader object which is a forward-only resultset. (4)ExecuteXMLReader:- This method is available for SQL Server 2000 or later. Upon execution it builds XMLReader object from standard SQL

Discussion