Sequence to connect and retrieve data from database useig
dataset ?

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 This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What providers does Ado.net uses?

786


What is acid in ado.net?

740


Explain the difference between ado and ado.net?

714


What do you know about ADO.NET's objects and methods?

749


What are the main differences between classic ado and ado.net?

764


What are the benefits of using ado.net?

737


What is ado.net and its architecture?

752


Does dapper use ado.net?

803


What are the essential features of ado.net?

740


Explain how do you connect to sql server database without using sqlclient?

727


What is executequery?

706


What are good ado.net object to replace to ado recordset object.

810


What is DataReader Object?

800


Define Execute Scalar?

772


Which is the feature of ado.net?

768