Interested to Buy Any Domain ? << Click Here >> for more details...
What is sequence of code in retrieving data from database ?
- 3 Answers
- 15167 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
What is fill method in ado.net?
What are the different methods available under the sqlcommand class to access the data?
Which ado.net object is very fast in getting data from the database?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What are the namespaces used in ADO.Net to connect to a database?
Explain why edit is not possible in repeater?
What is aggregating data ?
What is the difference between executequery and executenonquery?
What are the key features of ado.net?
How can you add or remove rows from the datatable object of dataset?
What is the full form of ado?
What is dataadapter in ado.net?
What is ado net stands for?
What is command class in ado.net?
Explain the difference between ado and ado.net?
