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
How does entity framework work?
What is difference between entity framework and ado.net?
What is the namespaces being used to access oracle database?
What is namespace in ado.net?
Explain the difference in record set and dataset?
What is the default Timeout for SqlCommand.CommandTimeout property?
Can you explain how to enable and disable connection pooling?
Define atomicity?
What is ole access?
What does ado stand for in ado.net?
How does ado.net work?
Define bubbled event?
What is a dynaset in access?
What are the classes in System.Data.Common Namespace?
What is the executescalar method?