about datalist and access datasource

[miladhatam@gmail.com]

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
AccessDataSourc e1.SelectComman d = "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

[miladhatam@gmail.com]

Re: about datalist and access datasource

i did it myself
protected void Page_Load(objec t sender, EventArgs e)
{
int range = 2;
int p = Convert.ToInt16 (Request["page"].ToString());
if ( p ==0)
p=1;
if (DataList1.Item s.Count % range 0)
{

numeric1.listSi ze = (DataList1.Item s.Count / range) + 1;
}
if (DataList1.Item s.Count % range == 0)
{
numeric1.listSi ze = (DataList1.Item s.Count / range);

}
if (p == 1)
{
for (int i = range; i < DataList1.Items .Count ; i++)
{
DataList1.Items[i].Controls.Clear ();
}
}
else
{
for (int i = 0; i < (p-1)*range ; i++)
{
DataList1.Items[i].Controls.Clear ();
}

for (int i = range*(p) ; i < DataList1.Items .Count; i++)
{
DataList1.Items[i].Controls.Clear ();
}

}
}