Answer Posted / suresh

Pessimistic locking, last-win-approach and optimistic
locking

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?

1932

---

What is aggregating data ?

516

---

Explain what are acid properties?

544

---

Describe connection object in ado.net

545

---

What is ole db and odbc?

521

---

---

How can we add relation between tables in a dataset?

549

---

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

620

---

What are the data providers used in ado.net

546

---

What are dataproviders?

551

---

What is adodb dll?

520

---

Explain the different row versions available in table?

553

---

Can we do database operations without using any of the ado.net objects?

539

---

What is shadow copy?

583

---

What is oledb driver?

499

---

What are the differences between OLEDB and SQLClient Providers?

569

---