If a table contains 20000 records . In a page at each time
100 records to be displayed. What are the steps u will take
to improve performance? will you use dataset or datareader?
Answer Posted / anna
we have to use datareader.
because it is more faster & efficient than dataset.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are three methods for displaying data in a syncfusion datagrid
Describe datareader object of ado.net with example.
how Sequence to connect and retrieve data from database using dataset?
What are the types of databinding?
Do you use stored procedure in ado.net?
Describe the command object and its method.
Explain ODP.net
What is ado and dao?
What is ole2 format?
What is sqldatareader in ado.net?
Which property is used to check whether a DataReader is closed or opened?
What are the difference between readonly vs. Const?
What are the different methods available under the sqlcommand class to access the data?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
How can you add or remove rows from the datatable object of dataset?