Answer Posted / srinivas.kinthada

i think oldb is not correct it's may b.
it is oledb

using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<username>;pwd=<password>;server=<servername>");
cn.open();

What is method to get XML and schema from Dataset? getXML() and get Schema ()

541

---

What are the rules to implement connection pooling?

506

---

How to check if the Dataset has records ?

530

---

List the 4 common ado.net namespaces?

697

---

What are the major challenges in accessing data from a database?

528

---

---

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

502

---

How to generate a single aggregate?

540

---

How do I delete a row from a DataTable?

593

---

What are the advantages and drawbacks of using ado.net?

622

---

What is the use of sqldatareader class?

475

---

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

617

---

What does datareader object do?

535

---

What is linq and entity framework?

514

---

Define ado.net?

573

---

What is sql connection in ado.net?

496

---