ADO.NET Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 5513

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,

2451

make a login control??

1 4146

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

2 6071

what is connection pooling ?

Vertex,

3 7874

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11596

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

SQL Star,

2 5645

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7412

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

2087

What are the attirbutes of DataSet?

IBM,

5 11456

What are the Different layers in ADO.Net?

eXensys,

10 19374

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 18223

types of Store procedure in Sqlserver2000?

4 10915

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

3 13875

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 17166

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is the advantage of ado.net?

1064

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1035

What are the benefits of ADO.NET?

1175

What is difference between ado and other data object?

971

What does ado stand for in ado.net?

1201

What is the difference between ADO and ADO.Net?

1127

How to work with disconnected data - the dataset and sqldataadapter?

1043

What is DataRowCollection?

1152

Why edit is not possible in repeater?

995

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

1114

What are the differences between OLEDB and SQLClient Providers?

1247

What are the important features of ado.net 2.0?

1118

What is openrowset?

1047

What is fill method in ado.net?

1039

What is connection in ado.net?

1002

For More Un-Answered { ADO.NET } Questions Click Here