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 DataReader class do in ADO.NET ?

823

---

What is connection string?

754

---

Does entity framework use ado.net?

752

---

Explain executenonquery?

833

---

What are all components of ADO.Net data provider?

823

---

What is ado data control?

776

---

What is the use of data grid?

742

---

Explain the basic use of "dataview" and explain its methods.

742

---

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

785

---

What is connection pooling and what is the maximum pool size in ado.net connection string?

751

---

What are the advantages of oledb compared with other classes?

2595

---

What are the Features of a dataset

935

---

What are the namespaces used in ado.net for data access?

737

---

What is a control toolbox?

735

---

Which method is used to sort the data in ADO.Net?

1778

---