Answer / Dharmendra Singh

The primary namespaces used in ADO.NET for data access are System.Data and System.Data.SqlClient (for SQL Server), System.Data.OleDb (for OLE DB providers), and System.Data.OracleClient (for Oracle databases).

What are the features of ado.net?

1 Answers  

---

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

Which is faster entity framework or ado.net?

1 Answers  

---

What happens when we issue Dataset.ReadXml command?

1 Answers  

---

What is the meaning of object pooling?

1 Answers  

---

How to work with disconnected data - the dataset and sqldataadapter?

1 Answers  

---

What is sequence of code in retrieving data from database ?

3 Answers   Accenture, BirlaSoft,

---

What is difference between entity framework and ado.net?

1 Answers  

---

What is disconnected architecture in ado.net?

1 Answers  

---

How is entity framework different from ado.net?

1 Answers  

---

Define data access layer?

1 Answers  

---

What is data reader in ado.net?

1 Answers  

---