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 5465

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,

2392

make a login control??

1 4082

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

2 5968

what is connection pooling ?

Vertex,

3 7764

What is the Magic Tables in Sqlserver2000?

IBM, SQL Star,

7 11394

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

SQL Star,

2 5549

How to Handle the exceptions in Sqlsrver2000

SQL Star,

3 7292

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

2037

What are the attirbutes of DataSet?

IBM,

5 11301

What are the Different layers in ADO.Net?

eXensys,

10 19114

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 17983

types of Store procedure in Sqlserver2000?

4 10795

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

3 13769

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 17067

Post New ADO.NET Questions

Un-Answered Questions { ADO.NET }

What is a datagridview?

1053

List the 4 common ado.net namespaces?

1178

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

1009

Which object holds only data and does not interact with data source?

1001

What are disadvantages of microsoft-provided data provider classes in ado.net?

1041

What is the difference between data reader and data adapter?

1040

What are datareaders?

990

What are all the commands used with Data Adapter?

1044

What is the difference between dataset and datatable?

1019

What is a column variable?

944

What is ado.net code?

938

How do you update a dataset in ado.net and how do you update database through dataset?

929

What are the usages of the command object in ado.net?

1027

What are the advantages and disadvantages of using datalist?

1090

What is data relation?

927

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