Interested to Buy Any Domain ? << Click Here >> for more details...
What is sequence of code in retrieving data from database ?
- 3 Answers
- 14837 Views
- Accenture, BirlaSoft, I also Faced
- E-Mail Answers
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
How can we add relation between tables in a dataset?
What is the difference between DataReader and DataSet in ADO.NET?
What is data reader in ado.net?
What is the difference between sqlcommand and sqldataadapter?
How do you merge 2 datasets into the third dataset in a simple manner?
What providers does Ado.net uses?
how can implement dropdownlist in particular of dataset when try to update?
What is ole db and odbc?
What is data access pattern?
Explain what are the steps to connect to a database?
How is entity framework different from ado.net?
What is a serialized object?
What is disconnected data?
Explain why edit is not possible in repeater?
Explain the difference between ado and ado.net?
