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 the usage of the dataset object in ado.net?

952

---

What is the difference between dataset and datatable?

994

---

What is the role of clr?

937

---

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

988

---

Which object needs to be closed?

2247

---

What is bubbled event can you please explain?

1028

---

What are the data access namespaces in .NET?

1197

---

How would you connect to database using .NET?

1023

---

What is oledb driver?

926

---

What is csdl entity framework?

1008

---

How to copy the contents from one table to another table and how to delete the source table in ado.net?

1023

---

What do you know about ado.net's methods?

1100

---

What are basic methods of dataadapter?

960

---

Explain ado.net features? Benefits? Drawbacks?

1042

---

How can we check that some changes have been made to dataset since it was loaded?

962

---