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.

Is datareader faster than datatable?

912

---

What are the different methods available under the sqlcommand class to access the data?

999

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

930

---

Define the executescalar method?

877

---

What connected data?

890

---

What is the difference between sqlcommand and sqldataadapter?

947

---

What is Serialization in .NET? what are the types of Serialization?

1024

---

Do we use stored procedure in ADO.Net?

940

---

What is an example of ordinal data?

1046

---

What is connected architecture in ado.net?

973

---

What is ole used for?

889

---

What is the use of adodc?

939

---

What are the ado.net components?

965

---

What is data access pattern?

873

---

Can datareader hold data from multiple tables?

1114

---