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 providers does Ado.net uses?
What is acid in ado.net?
Explain the difference between ado and ado.net?
What do you know about ADO.NET's objects and methods?
What are the main differences between classic ado and ado.net?
What are the benefits of using ado.net?
What is ado.net and its architecture?
Does dapper use ado.net?
What are the essential features of ado.net?
Explain how do you connect to sql server database without using sqlclient?
What is executequery?
What are good ado.net object to replace to ado recordset object.
What is DataReader Object?
Define Execute Scalar?
Which is the feature of ado.net?