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 5457

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,

2382

make a login control??

1 4071

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

2 5957

what is connection pooling ?

Vertex,

3 7747

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11367

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

SQL Star,

2 5537

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7279

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

2029

What are the attirbutes of DataSet?

IBM,

5 11289

What are the Different layers in ADO.Net?

eXensys,

10 19086

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 17956

types of Store procedure in Sqlserver2000?

4 10781

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

3 13763

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 17053

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What are the ado.net objects?

944

What are all the classes that are available in System.Data Namespace?

1013

Describe briefly an ADO.NET Dataset ?

1089

Which property is used to check whether a DataReader is closed or opened?

1050

Explain the difference between ado and ado.net?

941

What are the data providers used in ado.net

1021

What is the difference between statement and preparedstatement interface?

999

What is data relation in ado.net?

1078

What is the role of data provider in ado.net?

999

Define the data provider classes that is supported by ado.net?

982

What are all features of ADO.Net?

984

What are the features of ado.net?

1040

What does executereader return?

982

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

1008

What DataReader class do in ADO.NET ?

1099

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