Answer Posted / m.chandran

Connection String for SQL Server consist of:
1.Data Source or server= “.”; or "Localhost" or "127.0.0.1" or "serverNameinstanceName" or "N/W SQL server IP Address" Server instance.
2.Initial Catalog or database = “DATABASE_NAME”;
Either3.Uid=”UserID for SQL server” and Password= “Password for SQL server”;
ORIntegrated Security=”True”; Use Windows security

optional
5.Provider Name =”System.Data.SqlClient”;

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

915

---

Why do we use sqldataadapter?

907

---

What are the benefits of using ado.net?

947

---

Which control of the BindingNavigator returns the current position within the data source?

1109

---

What is the difference between an ADO.NET Dataset and an ADO Recordset?

990

---

How to create dynamic gridview?

978

---

Explain advantages of ado.net?

998

---

What are the Features of a dataset

1182

---

What is executequery?

897

---

Explain how to pass multiple tables in datasets simultaneously?

985

---

Is it possible to load multiple tables in a Dataset?

1000

---

Explain the difference between sqlcommand object and command behavior object?

1007

---

What are the difference between readonly vs. Const?

940

---

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

915

---

What are the advantages and disadvantages of using datalist?

984

---