Interested to Buy Any Domain ? << Click Here >> for more details...
What is sequence of code in retrieving data from database ?
- 3 Answers
- 15017 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
Which is the best method to get two values from the database?
How to connect and retrieve data from database using dataset
Which is the feature of ado.net?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
Which object needs to be closed?
What are the Data providers in ADO.Net?
What is XML serialization
What is data reader in ado.net?
What is ado oledb and odbc?
Why do we use sqldataadapter?
What is ado data control?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
How do you update a dataset in ado.net?
Define atomicity?
