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 meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

0 Answers  

---

Which object of ado contains datarow datacolumn collection?

0 Answers  

---

What are the major challenges in accessing data from a database?

0 Answers  

---

What is the difference between Command and CommandBuilder object?

0 Answers  

---

What are the two fundamental objects in ADO.NET?

6 Answers  

---

Which namespaces are used for data access?

0 Answers   SwanSoft Technologies,

---

What are all features of ADO.Net?

0 Answers  

---

How to pass values into a datatable?

0 Answers  

---

What are two types of transaction supported by ado.net?

0 Answers  

---

What are the advantages of using datalist?

0 Answers  

---

Explain the difference between data reader and data adapter?

0 Answers  

---

What is the meaning of executenonquery?

0 Answers  

---