set the number of records per page to 250, since you want to see 250-500 and on set the pageindex to 1.
On Sun, Dec 21, 2008 at 4:54 AM, VB <[email protected]> wrote: > > I don't want to change SQL, because I am using this somewhere else > also.....so any other solution to perform such action ?? > > On Dec 21, 2:43 am, CK <[email protected]> wrote: > > select top 250 * from table1 where pkField not in (select top 250 > > pkField from table1) > > > > On 19 Dec, 19:15, VB <[email protected]> wrote: > > > > > > > > > I want to show records from number 250 to 500 in GridView but writing > > > SQL as "Select * from table1"- Hide quoted text - > > > > - Show quoted text - >
