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
5374 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

What is a datareader object?

0 Answers

I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception.

2 Answers Fulcrum Logic, Satyam,

How to creating a SqlCommand Object?

0 Answers Arigo Infotech,

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers

What is an ADO.Net?

0 Answers

What are the parameters that control most of connection pooling behaviors?

0 Answers

Which method is used by command class to execute SQL statements that return single value?

0 Answers

What?s the role of the DataReader class in ADO.NET connections?