What is sequence of code in retrieving data from database ?
- 3 Answers
- 13659 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 steps to connect to a database?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What are typed and untyped dataset?
What is sqldatareader in ado.net?
What are the pre-requisites for connection pooling?
What is difference between datagridview and datagrid control in winforms?
Define different execute methods of ADO.NET command object ?
What is the role of data provider in ado.net?
What is openquery?
What are the rules to implement connection pooling?
How can I retrieve two tables of data at a time by using data reader?
What are dcl commands?
What we do with the object of ado.net dataset after using it?
What are the advantages of using datalist?
What is basic use of data view?
