How do we invoke queries from the application ?
Answers were Sorted based on User's Feedback
Answer / vivek
Command object is only one to execute queries in the
backend.
Ex:
SqlConnection cn=new SqlConnection();
SqlCommand cmd=new SqlCommand("SELECT * FROM EMP",cn);
cmd.ExecuteNonQuery();
cmd.ExecuteReader();
cmd.ExecuteScalar();
Cmd.ExecuteXmlReader();
command object has only these 4 methods to execute queries
in the backend.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shwetha
by the namespace using System.Data.Sqlclient
by using Sqlcommand
Dim cmd as new Sqlcommand("Queries");
| Is This Answer Correct ? | 4 Yes | 2 No |
how to keep track of index in listbox items.
What is the functionality of data provider in ado.net?
What are the differences between RAW, AUTO and Explicit modes in retrieving data from SQL Server in XML format?
Why DataReader is Forward Only?
What is data access pattern?
What is ambient transaction?
can u tell me the why ADO does not support xml..
What is the use of command objects?
Which method is used to sort the data in ADO.Net?
What are all components of ADO.Net data provider?
feature of ADO.Net
What is namespace in ado.net?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)