Answer / vijendra singh

Use The following Query for the problem...

Declare @PageIndex int
set @PageIndex=1
Declare @PageSize int
set @PageSize=20
while @PageIndex < 1000
begin
SELECT * FROM test WHERE ID between
@PageIndex and @PageIndex+@PageSize-1
set @PageIndex = @PageIndex + 20
end

Answer / santosh

u can easily done by the use of Row_number() in sqlserver.

Ex:-

declare @Lower_Bound int,@Upper_bound int
SET @Lower_Bound=1 -- change this as per requirement
SET @Upper_bound=20 -- change this as per requirement
Select Id,Name from(select row_number()over(order by id asc) as Temp_Id,Id,Name from M_Student)
M_Student where Temp_Id >=@Lower_Bound and Temp_Id<=@Upper_bound


Here My Table Name is M_Student(Id,Name) & I have made a Temporary Id column(Temp_Id).Here the result.
Thank U......

If any query then u can connect me through

santosh.primetechsoftware@gmail.com

Answer / rasbeer

Declare @PageIndex int
set @PageIndex=2

select top 20 * from
(select top 20 * from
(select top (@PageIndex*20) * from chat_contents order by
id ) as a1
order by id desc)as b1 order by id

Answer / chinnu

select top 20 * from table-name

Answer / irfan

select * from table name where rownum <= 20;

Answer / sunny

Assume EMP is my Table where 1000 Records there. We retrive
20 top record from database through by following c# code.
}
sqlconection cn = new sqlconnection(@"Conection string...");
dataset ds = new dataset();
SqldataAdapter da = new SqldataAdapter("select top 20 *
from Emp", cn);
da.fill(ds);
Gridview1.datasource = ds.table[0];
Gridview1.databind();
}

Answer / gowtham

you can also use Set Rowcount keyword to fetch the records
from sql server.Here is the query for that:

Set Rowcount 20
Select Empname from emp
Set RowCount 0

Answer / raj

select top 20 * from tablename order by newid()

Answer / arunbhararthi

you can use top keyword to fetch the first 20 records from
sql server.Here is the query for that:

for example:
select top20 empname from emp.

What r the remotable objects. and how u make an application remotable

1 Answers  

What is bound controls

0 Answers   MCN Solutions,

How can you ensure a permanent cookie?

0 Answers  

What are ASP.NET Web Forms? How is this technology different than what is available though ASP?

1 Answers   BirlaSoft,

How to display Alert in ASP.NET

0 Answers   HCL,

What are the namespaces used in asp.net mvc? : asp.net mvc

0 Answers  

If i have 1000 records in dataset, how to do paging?

2 Answers   Mind Tree,

How .net CLR works with n-tier application

4 Answers   HCL, Hughes,

can s/w quality assurance engineer switch field to programming side i m very much interested in programming but not much good in it

0 Answers  

How to Convert a String into Float without using any built- in library of .NET String = "1235.45" needs to converted to a float

2 Answers   CA, Microsoft,

Have u used webcontrols?Tell me something about these?

2 Answers   Microsoft,

1.how to encrpt query string in asp.net? 2.there are 10000 records then i wnat display 5000 records one gridview and 5000 records another grid view what is the process?

2 Answers   Marlabs,