What is sequence of code in retrieving data from database ?
Answer Posted / manoj batra
If using DataSet :
1) Create a connection object
2) Create a DataAdapter object
3) Associate your query and connection with DataAdapter
4) Create DataSet object
5) Fill the dataset with desired result using Fill method of
DataAdapter.
6) start retriving the data into your container from dataset.
Note : DataAdapter automatically Open and Close the connection.
If using DataReader:
1) Create connection object
2) Oen connection
3) Create Command object
4) Create DataReader object
5) Associate your Sql command with the command object
6) Use ExecuteDataReader method inside the loop (The
selective Sql query may return more than one Row)
Note : DataReader is Readonly and ForwardOnly operation.
7) Return result in control(s).
8) Close the connection
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
describe the dataset object in ado.net.
Explian About DataAdapters
What is ado.net objects?
Is it possible to load multiple tables in a Dataset?
What is datasource in ado.net?
What is an ado connection?
What is an ado?
What are the different layers of ado.net?
Define data access layer?
Why do we use sqldataadapter?
What is serialization and de-serialization in .net?
Where is adodb dll located?
Explain the two fundamental objects in ado.net?
Which ado.net object is very fast in getting data from the database?
What is ole in vb?