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 5506

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,

2445

make a login control??

1 4138

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

2 6061

what is connection pooling ?

Vertex,

3 7859

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11567

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

SQL Star,

2 5632

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7398

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

2080

What are the attirbutes of DataSet?

IBM,

5 11437

What are the Different layers in ADO.Net?

eXensys,

10 19339

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 18190

types of Store procedure in Sqlserver2000?

4 10903

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

3 13856

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 17156

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is the difference between sqlcommand and sqldataadapter?

1037

What you mean by filtering of data?

1013

What is the use of Dataview?

1189

Explain ODP.net

1061

Which is the best method to get two values from the database?

1011

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

1048

How can we check that some changes have been made to dataset since it was loaded?

1016

What is the difference between SqlCommand and SqlCommandBuilder?

1139

What is ado object model?

992

Explain the architecture of ado.net?

1129

What is data access pattern?

1001

Difference between sqlcommand and sqlcommandbuilder?

1189

Which method is used by command class to execute SQL statements that return single value?

1091

What is ado net stands for?

1009

Define data access layer?

1009

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