about datalist and access datasource
- From: "miladhatam@xxxxxxxxx" <miladhatam@xxxxxxxxx>
- Date: Sun, 28 Sep 2008 07:39:02 -0700 (PDT)
hi
how can i show every 10 records of my db in datalist in several page
i want to get it the paging property
i even wrote this code
AccessDataSource1.SelectCommand = "SELECT * FROM table1 where id
between " + (page - 1) * 10 + " and " + (page * 10 - 1) ;
but it works when my 'id' have a correct sequence of number
you know for example when you have 3 records with id 1,2,3 and when
you delete second record after that you have 2 records but your new
second record's id is still 3
and it make a mistake
what is your soloution for paging the datalist?
thanks
.
- Follow-Ups:
- Re: about datalist and access datasource
- From: miladhatam@xxxxxxxxx
- Re: about datalist and access datasource
- Prev by Date: Re: Controller or LINQToSQL Wrapper. Need advice ...
- Next by Date: Re: sql membership provider setup
- Previous by thread: sql membership provider setup
- Next by thread: Re: about datalist and access datasource
- Index(es):