What Are The Different Execute Methods Of Ado.net?

1.	What Are The Different Execute Methods Of Ado.net?
Answer» FOLLOWING are different execute methods of ADO.Net command object: ExecuteScalar – Returns SINGLE value from the dataset ExecutenonQuery – Returns resultset from dataset and it has multiple values ExecuteReader – Forwardonly resultset ExecuteXMLReader – BUILD XMLReader object from a SQL QUERY Following are different execute methods of ADO.Net command object: ExecuteScalar – Returns single value from the dataset ExecutenonQuery – Returns resultset from dataset and it has multiple values ExecuteReader – Forwardonly resultset ExecuteXMLReader – Build XMLReader object from a SQL Query

Answer»

FOLLOWING are different execute methods of ADO.Net command object:
ExecuteScalar – Returns SINGLE value from the dataset
ExecutenonQuery – Returns resultset from dataset and it has multiple values
ExecuteReader – Forwardonly resultset
ExecuteXMLReader – BUILD XMLReader object from a SQL QUERY

Following are different execute methods of ADO.Net command object:
ExecuteScalar – Returns single value from the dataset
ExecutenonQuery – Returns resultset from dataset and it has multiple values
ExecuteReader – Forwardonly resultset
ExecuteXMLReader – Build XMLReader object from a SQL Query

Discussion

No Comment Found

Related InterviewSolutions

What Are All The Different Authentication Techniques Used To Connect To Ms Sql Server?
What Are The Methods Of Xml Dataset Object?
Do We Use Stored Procedure In Ado.net?
Which Provider Is Used To Connect Ms Access, Oracle, Etc…?
Is It Possible To Load Multiple Tables In A Dataset?
What Is The Difference Between Command And Commandbuilder Object?
What Is The Difference Between Dataset.clone And Dataset.copy?
What Are All The Different Methods Under Sql Command?
What Are All The Commands Used With Data Adapter?
What Are The Different Execute Methods Of Ado.net?