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 difference between a datareader and a dataset?

1043

---

What is ole2 format?

904

---

Explain advantages of ado.net?

1052

---

What is the default timeout specified for "sqlcommand.commandtimeout" property?

1054

---

What are the advantages and drawbacks of using ado.net?

1110

---

Why do we serialize data?

951

---

Which object is used to add relationship between two Datatables?

1047

---

How to creating a SqlCommand Object?

1149

---

What is different between sqlcommand object and command behavior object?

1062

---

What are the steps to connect to a database?

1024

---

What is the return type of executescalar?

1019

---

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

978

---

What is the difference between statement and preparedstatement interface?

1000

---

What are the classes in System.Data.Common Namespace?

1151

---

What are the core objects of ADO.NET?

1048

---