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 |
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is ado.net objects?
What is two way data binding android?
Can I use One Data Set for More than one Data Adapter?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is difference between datagridview and datagrid control in winforms?
What is ole used for?
What is adodb dll?
Define data access layer?
Explain the basic use of "dataview" and explain its methods.
How to retrieve the user id which is provided while windows authentication?
how can implement dropdownlist in particular of dataset when try to update?
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)