Answer / shashikant kothavale

in my project as we used sql server as back end i have used
sqlclient namespace and system io namespace to read
values/data from non database file via comm separated values!

other data providrs are

oledb;
sqlclient;
oraclclient,
odbc etc

Answer / rahul singhal

in vb.net for sql server
imports system.data
imports system.data.oledb
imports system.data.sqlclient

in c# for sql server
using system.data
using system.data.oledb
using system.data.sqlclient

Answer / ashokdahiya

system.data
system.data.oledb
system.data.sqlclient

What is microsoft ado?

0 Answers  

---

What do you mean by ‘batch updates’?

0 Answers  

---

What is data adapter in ado.net with example?

0 Answers  

---

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

---

Diff B/W DataSet vs DataTable

6 Answers   Star Wire,

---

---

How do I delete a row from a DataTable?

0 Answers   UGC Corporation,

---

What is a datatable?

8 Answers   State Bank Of India SBI,

---

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 meant by executenonquery?

0 Answers  

---

What are the differences between OLEDB and SQLClient Providers?

0 Answers  

---

What are the connected and disconnected modes in ado.net?

0 Answers  

---

Which architecture does Datasets follow?

0 Answers  

---