Answer Posted / sudhir kumar pal

ADO.NET Command Object - The Command object is similar to
the old ADO command object. It is used to store SQL
statements that need to be executed against a data source.
The Command object can execute SELECT statements, INSERT,
UPDATE, or DELETE statements, stored procedures, or any
other statement understood by the database. See sample
code...

'Code below in VB.NET ...
Dim ObjCom as SqlClient.SqlCommand
ObjCom.SqlConnection(strCon)
ObjCom.Connection.Open()
ObjCom.CommandText = "Select * from tblSample"
ObjCom.ExecuteNonQuery()


SqlCommand objects are not used much when we use datasets
and data adapters. Following are some properties of the
SqlCommand class...

What are the 3 major types of connection objects in ado.net?

948

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1279

---

What is microsoft ado.net?

1078

---

What is a string variable?

874

---

What is the role of clr?

902

---

How do you implement locking concept for dataset?

949

---

What are the benefits of using of ADO.NET in .NET 4.0?

998

---

What is ole used for?

900

---

How do I delete a row from a DataTable?

1084

---

What is csdl entity framework?

976

---

What is ado.net in vb net?

880

---

What are the major difference between classic ADO and ADO.NET?

949

---

What are all the commands used with Data Adapter?

982

---

What are the types of databinding?

940

---

What is ole in excel?

903

---