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.

What are two types of transaction supported by ado.net?

991

---

Explain which name space is used to get assembly details?

959

---

How to pass values into a datatable?

1125

---

Which is the best method to get two values from the database?

965

---

Define atomicity?

1019

---

What are the different layers of ado.net?

1071

---

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

1042

---

What does executereader return?

966

---

Define bubbled event?

922

---

How to store data in memory?

946

---

How can you add or remove rows from the datatable object of dataset?

1021

---

What is ado asp?

986

---

Do we use stored procedure in ADO.Net?

987

---

Define the executescalar method?

934

---

What are basic methods of dataadapter?

966

---