How many major types of connection objects in ADO.NET?

1 Answers   MCN Solutions,

---

What is the difference between Optimistic and Pessimistic locking?

1 Answers  

---

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

1 Answers   Nimaya,

---

What you mean by filtering of data?

1 Answers  

---

Is it possible to edit data in Repeater control?

1 Answers  

---

what is clustered index?why is it created?

4 Answers   Microsoft, Wipro,

---

What are datareaders?

1 Answers  

---

If a table contains 20000 records . In a page at each time 100 records to be displayed. What are the steps u will take to improve performance? will you use dataset or datareader?

7 Answers  

---

Explain how can we load multiple tables in to dataset?

1 Answers  

---

What is the difference between linq and ado.net?

1 Answers  

---

How would you connect to a database by using .NET?

1 Answers  

---

What are the uses of Stored Procedure?

1 Answers  

---