ADO.NET Interview Questions
Questions Answers Views Company eMail

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

Nimaya,

1 4800

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

Infosys, Wipro,

1918

make a login control??

1 3345

how to add a selected row of a gridview to another gridview without reloading the page??

2 4857

what is connection pooling ?

Vertex,

3 6578

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 9189

What is reference by value how does it works in .net?

SQL Star,

2 4422

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 6059

The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

1562

What are the attirbutes of DataSet?

IBM,

5 9077

What are the Different layers in ADO.Net?

eXensys,

10 16276

i have two textboxes one for user name and another for password . i have a table name compare(which contains name,passwod etc.,)my doubt is how compare username textbox with name column and how compare password textbox with passwod column. i want the code

Wipro,

9 15293

types of Store procedure in Sqlserver2000?

4 9260

what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 12338

explain connection less and with connection?diference between data reader,data set,data adapter? can we use data reader,data set in a single application? if yes explain with simple code,if no explain?

Techno Labs,

3 15860


Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

Can we connect two dataadapters to same data source using single connection at same time?

524


What is disconnected architecture in ado.net?

492


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

526


What is ado or jdbc?

505


What is a datareader object?

571






Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

622


Name which operations can you not perform on an ado.net dataset?

474


If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

603


What is the default timeout specified for "sqlcommand.commandtimeout" property?

531


What is command class in ado.net?

465


What is ado.net code?

512


Where is adodb dll located?

515


What is the use of adodc?

519


Explain executenonquery?

547


Is bulk insert faster than insert?

482