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.

In asp.net, if a webpage seems too slow to load completely in th ebrowser. In this case what are the checkings or actions you will take to rectify the slowness or which are the factors related to this issue? How we can trace it?

3 Answers  

How to retrieve data row by row from a DataTable? Thanks In advance PriyaPP

3 Answers  

How do I know asp.net mvc version? : Asp.Net MVC

0 Answers  

How can you handle exceptions in asp.net?

0 Answers  

Do I need to have the latest version of windows media player installed?

0 Answers  

How do we assign page-specific attributes?

0 Answers  

How do you register a .NET assembly?

3 Answers   Microsoft,

What is considered a service provider?

0 Answers  

Where we create sessions for Banking Applications and how to create? expalin with code?

1 Answers   Wipro,

Explain significance of routing? : asp.net mvc

0 Answers  

What is difference between datalist and gridview?

0 Answers  

Explain what a diffgram is, and a good use for one?

2 Answers