Answer / vijay

we have to use a dataset because on using datareader
forward only paging can be achieved. Suppose if you are at
1000 page and you want to go back to 999th page, if you use
datareader it cannot be achieved, since it does not support
backward navigation.
Dataset supports forward and backward navigation

Answer / anna

we have to use datareader.
because it is more faster & efficient than dataset.

Answer / ashok

This can be done using following ways. Mainly its base on
multitreading environment.

1. Declare delegate (I am using Async delegate)
2. Start a new thread which will gets a data information in
collection or we can fill the dataset.
3. In main thread you can keep polling to the datafill
thread whether the operation is complete or not.
4. with IAsyncResult we can find whether the thread which we
started earlier has completed the assigned task or not.

Answer / renjith t n

You need to look at ROW_NUMBER() to do this effectively.
Temp tables, cursors are to costly.

CREATE PROCEDURE myProc

@StartIndex INT
@MaxRecords INT

AS

SET @StartIndex = @StartIndex + 1

SELECT
first_name,
last_name,
middle_init
FROM
(SELECT
first_name,
last_name,
middle_init
ROW_NUMBER() OVER(ORDER BY last_name)
AS rownum
FROM
Users)
AS Users
WHERE
rownum between @StartIndex and (@StartIndex + @MaxRecords) -
1

Then we can use Dataset for best performance..

Answer / vijay

answer # 3 is really appreciate me thanks for giving
correct answer. i ve tested with sqldatasource with
gridview and change datasourcemode to datareader giving
error u must use dataset..

Answer / kumar vaibhav

Create a stored procedure with parameter page size and current page index.Get the lower bound and upper bound of the page by using following formula

Lower bound=Pagesize*PageIndex+1
Upper Bound=lowerbound+pagesize

call this Stored Procedure on every paging event of gridview.

Answer / nitin

DataReader is better Choice for this type of Task becoz
DataReader is Read only, forward only access to data in
Connected Environment.

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

Which is faster entity framework or ado.net?

0 Answers  

Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,

Differentiate between Dataset and Recordset.

2 Answers  

What is ado.net architecture?

0 Answers  

Can we connect two dataadapters to same data source using single connection at same time?

0 Answers  

What is the use of Dataview?

0 Answers  

What are the data providers in ADO.NET framework?

0 Answers  

Define the data provider classes that is supported by ado.net?

0 Answers  

Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,

What are the parameters that control most of connection pooling behaviours?

0 Answers  

How do I delete a row from a DataTable?

0 Answers   UGC Corporation,