OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

---

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

0 Answers  

---

What is disconnected scenario in entity framework?

0 Answers  

---

Does executenonquery return a value?

0 Answers  

---

How to create data relations?

0 Answers  

---

---

How to identify the updated rows in a dataset?

0 Answers  

---

can u tell me the why ADO does not support xml..

2 Answers   Crea,

---

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...

6 Answers  

---

How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,

---

How to pass multiple tables in datasets simultaneously?

0 Answers  

---

What are the drawbacks of using ado.net?

0 Answers  

---

What is ADO .NET and what is difference between ADO and ADO.NET?

7 Answers   Ksb,

---