How do we invoke queries from the application ?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between the clone() and copy() methods of the dataset class?
What are basic methods of dataadapter?
What are the differences between OLEDB and SQLClient Providers?
Name which operations can you not perform on an ado.net dataset?
What is ado.net tutorial?
Is it possible to edit data in Repeater control?
Define atomicity?
What is the full form of ado?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What are the data providers in ADO.NET framework?
Why is stored procedure used in ado.net?
What are the key events of sqlconnection class?
Give an example that shows how to execute a stored procedure in ado.net?
What connected data?
What is the difference between ado.net and entity framework?