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 |
What is data reader in ado.net?
What is read only and forward only in ado.net?
Explain how can we load multiple tables in to dataset?
Which namespaces are used for data access?
0 Answers SwanSoft Technologies,
What does datareader object do?
What is the use of Dataview?
HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND PROGRAMING?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is ado asp?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What are different types of Commands available with DataAdapter ?
What is difference between ado.net and asp net?