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


Other Important Questions
Export GridView to excel
Set table name in dataset
What is connection pooling and its parameter
Connection and Disconnected Scenario in ADO.Net
What is DataRelation with example in ADO.NET







 
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 |