Answer / rajesh

SqlClient namespace is used to connect microsoft sqlserver
database while OLEDB namespace is used to connect older
databases such as ms access and mysql

Answer / dhana

sqlclient is exclusively for sqlserver as backend while
oledb is for access,sqlserver,oracle

using sqlclient provides extra functions while using
sqlserver as backend

What is meant by executenonquery?

0 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,

---

What is untyped dataset?

0 Answers  

---

Where is adodb dll located?

0 Answers  

---

What are the usages of the command object in ado.net?

0 Answers  

---

What is the difference between OLEDB Provider and SqlClient?

0 Answers  

---

What are all the different authentication techniques used to connect to MS SQL Server?

0 Answers  

---

What is a datagridview?

0 Answers  

---

What is the difference between executenonquery () and executescalar ()?

0 Answers  

---

what is a dataset?

9 Answers   Choice Solutions,

---

What is ole db query?

0 Answers  

---

how to display empty table to datagrid

3 Answers   LG Soft,

---