Answer Posted / srinivas

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

here u declare <user_name> is u give username
pwd is u give password
<server> or data source is u give

What are the data providers in ADO.NET framework?

791

---

How to generate a single aggregate?

754

---

Where is adodb dll located?

741

---

Describe connection object in ado.net

771

---

How can we save all data from dataset?

744

---

What is a data control clerk?

792

---

How to add a check box or a dropdown list to a column in a datagrid?

751

---

What are the rules to implement connection pooling?

770

---

What are the ado.net components?

777

---

What is ado.net components?

701

---

What is data reader in ado.net?

729

---

What are the Features and disadvantages of dataset

796

---

Do you use stored procedure in ado.net?

788

---

Why edit is not possible in repeater?

714

---

What are two types of transaction supported by ado.net?

763

---