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 aggregating data across related tables?
How do you connect to sql server database without using sqlclient?
What is the full form of ado.net?
What is ado.net components?
How many commands does the oledbcommand takes?what are they?
What is a sqldataadapter?
How do you find the count of records in a dataset?
What are the different row versions available in table?
ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?
i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.
what is sql Injection?
List the 4 common ado.net namespaces?
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)