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 5378

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,

2335

make a login control??

1 3980

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

2 5808

what is connection pooling ?

Vertex,

3 7582

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11059

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

SQL Star,

2 5423

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7135

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

1970

What are the attirbutes of DataSet?

IBM,

5 11048

What are the Different layers in ADO.Net?

eXensys,

10 18714

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 17584

types of Store procedure in Sqlserver2000?

4 10597

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

3 13627

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 16922

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

Explain the difference between data reader and data adapter?

910

Which parameter of ConnectionString is used to specify the name of the database?

989

What do you know about ado.net's objects?

942

Which database is the ado.net sql connection object designed for?

998

What is connection in ado.net?

891

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

958

What are the benefits of using of ADO.NET in .NET 4.0?

987

What are the Data providers in ADO.Net?

956

What is the difference between SqlCommand and SqlCommandBuilder?

1003

What are all components of ADO.Net data provider?

1007

Explain how to find the given query is optimised one or not?

951

What is an orm, and why would you use one instead of plain old ado.net?

996

What are the major difference between classic ADO and ADO.NET?

941

What are all features of ADO.Net?

933

What is the provider being used to access oracle database?

939

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