Hi Guest 1 HomePage 1 Jobs 1 WalkIn 1Articles  

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JAVASCRIPT
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 :) Latest Articles
 


  

 
Define different execute methods of ADO.NET Command Object
Classified Posted on 09 Mar 2019

Home >> DotNet >> ADO.NET >> Define different execute methods of ADO.NET Command Object



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







 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |