Answer Posted / vaidyanathan r.

The sequence is
Step 1: Create a Connection Object with Connection String
Eg: <Provider**>Connection ActiveConnection = new
<Provider**>Connection(<ConnectionString>)

Step 2: Create a Command Object with Command Text and the
created Connection Object

Eg: <Provider**>Command Qry = new <Provider**>Command
(<Command Text>, ActiveConnection)

Step 3: Set the command Type for the created Command
Eg: Qry.CommandType = CommandType.Text

Step 4: Create Data Adapter with the created Command
Eg: <Provider**>DataAdapter da = new
<Provider**>DataAdapter(Qry*);

Step 5: Create a DataSet Object.
Eg: DataSet ds = new DataSet();

Step 6: populate the dataset by calling the fill method of
Data adaper against the Data set object
Eg: da.Fill(ds);

__________________________________________________________
*Qry contains a select query (or) Stored Procedure Name
containing a Select Query

** If the provider is SQL server then the Connection type
is SQLConnection, Command type is SQLCommand and Data
adapter type is SQLDataAdapter.

Does dapper use ado.net?

1071

---

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

1016

---

What is difference between datatable and dataset?

1125

---

What is the difference between typed and untyped dataset?

1159

---

What are the data providers used in ado.net

1061

---

How can I retrieve two tables of data at a time by using data reader?

1081

---

Explain the difference between data reader and data adapter?

1015

---

What does executequery return?

1025

---

What are the pre-requisites for connection pooling?

1059

---

What is ole access?

998

---

What is acid in ado.net?

1102

---

What are ado.net objects?

1198

---

Describe the command object and its method.

1045

---

how we can fire event in databound coulm in datagfrid withot using button?

1023

---

Explain how to create dynamic gridview?

1015

---