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

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

964

---

Why do we serialize data?

889

---

What is sqlconnection and sqlcommand?

1018

---

Explain how to create dynamic gridview?

927

---

How is it possible to get 2 tables of data at a time by using data reader?

913

---

What is data relation in ado.net?

1002

---

What are all the classes that are available in System.Data Namespace?

970

---

Define table relations?

932

---

What is the default provider in ado.net?

921

---

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

952

---

Explain how to find the given query is optimised one or not?

962

---

How to add a check box or a dropdown list to a column in a datagrid?

927

---

How to perform sorting on a table in ADO.NET?

980

---

Which is faster sqldataadapter and sqldatareader?

879

---

What is the difference between Data adaptor and Data set?

981

---