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”;

How do I delete a row from a DataTable?

1167

---

What is openrowset?

986

---

What is the difference between Data adaptor and Data set?

1041

---

How to pass values into a datatable?

1139

---

Which is faster dataset or datareader?

970

---

What are the usages of the command object in ado.net?

1024

---

What is the difference between Dataset. clone and Dataset.copy?

1049

---

How can we perform transactions in .net?

1061

---

How can we load multiple tables in a dataset?

1182

---

Explain ado.net features? Benefits? Drawbacks?

1052

---

What is an ADO.Net?

993

---

How to find the given query is optimised one or not?

979

---

Explain all the classes those are used for database connections between sql server and asp.net?

1009

---

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

1045

---

What are the various methods provided by the DataSet object to generate XML?

1004

---