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.

Answer / shwetha

by the namespace using System.Data.Sqlclient


by using Sqlcommand

Dim cmd as new Sqlcommand("Queries");

What is the difference between sqlcommand and sqldataadapter?

0 Answers  

---

What is difference between datatable and dataset?

0 Answers  

---

What are the advantages of ado.net?

0 Answers  

---

What is @@rowcount and with small code snippet explain the usage?

4 Answers   BirlaSoft,

---

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

0 Answers  

---

Which is faster sqldataadapter and sqldatareader?

0 Answers  

---

Explain what are acid properties?

0 Answers  

---

Is ado.net an orm?

0 Answers  

---

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

0 Answers  

---

Define isolation?

0 Answers  

---

I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?

2 Answers  

---

What is ado connection?

0 Answers  

---