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
What is the use of connection object in ado.net?
What are the core objects of ADO.NET?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is the difference between sqlcommand and sqldataadapter?
What is connected architecture in ado.net?
What are the differences between OLEDB and SQLClient Providers?
How to retrieve the user id which is provided while windows authentication?
What are the advantages of ado.net?
Define connection string?
What do you know about ado.net's objects?
What are the objects of ado.net?
What is the functionality of data provider in ado.net?
What is DataReader Object?
What are the essential features of ado.net?
What is bubbled event?