Interested to Buy Any Domain ? << Click Here >> for more details...
What is sequence of code in retrieving data from database ?
- 3 Answers
- 14824 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 are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is a datareader object?
What is a dynaset in access?
What is sql command in ado net?
Explain the difference between ado and ado.net?
Name which operations can you not perform on an ado.net dataset?
Explain executenonquery?
What is the full form of ado.net?
What are the benefits of ADO.NET?
Explain all the classes those are used for database connections between sql server and asp.net?
What is the purpose of using adodb?
What is the functionality of data provider in ado.net?
Explain the basic use of "dataview" and explain its methods.
What Is Difference Between Ado And Ado.net?
Can datareader hold data from multiple tables?
