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 steps you will take to improve performance? Will you use dataset or datareader?

942

---

How would you connect to a database by using .NET?

902

---

Explain why edit is not possible in repeater?

999

---

How do you find the count of records in a dataset?

924

---

Is it possible to edit data in Repeater control?

905

---

What is a datagridview?

979

---

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

965

---

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

962

---

What is the difference between the clone() and copy() methods of the dataset class?

1030

---

What is difference between sqldatareader and sqldataadapter?

901

---

What is the role of the dataset object in ado.net?

1063

---

Define data adapter?

900

---

What are the Features and disadvantages of dataset

1043

---

Where is adodb dll located?

929

---

What is the meaning of object pooling?

1146

---