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 5450

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,

2378

make a login control??

1 4065

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

2 5946

what is connection pooling ?

Vertex,

3 7728

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11336

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

SQL Star,

2 5529

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7259

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

2020

What are the attirbutes of DataSet?

IBM,

5 11264

What are the Different layers in ADO.Net?

eXensys,

10 19036

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 17908

types of Store procedure in Sqlserver2000?

4 10770

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

3 13757

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 17033

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is ado circle?

1135

How to find the given query is optimised one or not?

971

What is serialization and de-serialization in .net?

925

What are the objects of ado.net?

1063

What is the use of data grid?

951

What are the advantages of ado.net?

907

Explain the difference in an abstract class and an interface?

919

What is data control techniques?

956

Explain the difference in record set and dataset?

933

What is disconnected scenario in entity framework?

1108

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

985

What is ado.net tutorial?

929

What is ole db and odbc?

917

How to bind the controls(best practice) comboboxes to the data in the dataset?

1044

What are the differences between OLEDB and SQLClient Providers?

1147

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