OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from

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

Question Posted / seemagirolkar

1 Answers
4421 Views
Nimaya, I also Faced
E-Mail Answers

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbCo..

Answer / shiva

what is the exception your faced????????
may be the exception is where your declare dataset11
in diconnected model we hav to declre the dataset then only
data willbe fiied in our application.......

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ADO.NET Interview Questions

FetCh Records No 5 to 10 From Dataset

4 Answers

Which is faster datareader or dataadapter?

0 Answers

What are different layers of ADO.Net?

0 Answers

Define different execute methods of ADO.NET command object ?