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
Explain ado.net features? Benefits? Drawbacks?
Which object needs to be closed?
What is partial class?
What is the difference between OLEDB Provider and SqlClient?
What is the meaning of executenonquery?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What are the Data providers in ADO.Net?
What is disconnected data?
What is an ADO.Net?
What is oledb driver?
What is bubbled event can you please explain?
What are the different execute methods of Ado.Net?
What is sql command in ado net?
How to load multiple tables into a dataset?
Can datareader hold data from multiple tables?