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 is connected architecture in ado.net?

1074

---

What is the difference between Datareader and Dataset?

1083

---

What is the difference between executenonquery () and executescalar ()?

957

---

Which is faster dataset or datareader?

970

---

Explain the difference between ado and ado.net?

941

---

What is datatable in ado.net?

969

---

What is the difference between DataReader and DataSet in ADO.NET?

1165

---

differences between ADO and ADO.NET

1078

---

What is a datagridview?

1044

---

What is commandbuilder in ado.net?

1031

---

What Is Difference Between Ado And Ado.net?

1033

---

What are all components of ADO.Net data provider?

1060

---

What is sqldatareader?

923

---

What is the provider being used to access oracle database?

998

---

Define isolation?

969

---