Define different execute methods of ADO.NET Command Object

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Define different execute methods of ADO.NET Command Object
Question 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

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

Getting Error DataControlRowType does not found in dotnet GridView?

Connection and Disconnected Scenario in ADO.Net

Error illegal characters in path while reading xml from dataset

Code to apply distinct keyword record on dataset table

Define different execute methods of ADO.NET Command Object

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)