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 |
Being fresher How would i answer to the question that what is your salary exception?
what is ado.net
How do you find the count of records in a dataset?
If we are not returning any records from the database, which method is to be used?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What is dataset object? Explain the various objects in dataset.
how to display empty table to datagrid
What are the three Ado objects?
6 Answers Microsoft, StarSoft,
What is ado.net code?
Difference between sqlcommand and sqlcommandbuilder?
What are disadvantages of microsoft-provided data provider classes in ado.net?
How is entity framework different from 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)