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 is microsoft ado.net?

580

---

What is fill method in ado.net?

543

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

535

---

Which is the feature of ado.net?

528

---

How is entity framework different from ado.net?

488

---

---

How to create dynamic gridview?

592

---

Explain the difference between sqlcommand object and command behavior object?

539

---

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

637

---

What providers does Ado.net uses?

579

---

Describe ado.net object model in detail.

534

---

Which is faster entity framework or ado.net?

502

---

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?

619

---

Explain the overview of ado.net architecture?

523

---

What is aggregating data ?

515

---

What are the essential features of ado.net?

541

---