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 pass values into a datatable?
How can we serialize the dataset object?
Does executenonquery return a value?
What is ado and rdo?
What is ODP.NET?
What is method to get XML and schema from Dataset?
What are the different namespaces used in the project to connect the database?
Describe the disconnected architecture of ADO.NET’s data access model.
How to Handle the exceptions in Sqlsrver2000
How to fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
Whate are different types of Commands available with DataAdapter ?
What is dbcontext and dbset in entity framework?
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)