Hi, I did paging like this
Class1 c = new Class1();
DALBase DBase = new DALBase();
protected void Page_Load(object sender, EventArgs e)
{
paging();
}
public int GetCount()
{
object retVal = DBase.ExecuteScaler(System.Data.CommandType.Text, "Select Count(*) As TotRows From Hospital", new OleDbParameter[]{
});
if (retVal != null)
return Convert.ToInt32(retVal);
else
return 0;
}
public void paging()
{
double TotRows = GetCount();
double Row_Per_Page = 15;
int PageCount =Convert.ToInt32( Math.Ceiling(TotRows / Row_Per_Page));
int Page_Number = 0;
if (TotRows!=0)
{
Page_Number = 1;
}
if (Request.QueryString["Page_Number"]!=null)
{
Page_Number=Convert.ToInt32(Request.QueryString["Page_Number"]);
}
int[] arr1 = new int[Convert.ToInt32(PageCount)];
for (int i = 1; i < arr1.Length+1; i++)
{
arr1[i-1] = i;
}
rpt_pager.DataSource = arr1;
rpt_pager.DataBind();
string sql2 = "Select TOP " + Row_Per_Page + " * From (Select TOP " + (TotRows - ((Page_Number - 1) * Row_Per_Page)) + " * From Hospital Order By Hid DESC) Order By Hid ASC";
OleDbDataReader dr = DBase.ExecuteReader(System.Data.CommandType.Text, sql2, new OleDbParameter[]{
});
Repeater1.DataSource = dr;
Repeater1.DataBind();
}
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("Name") %>'></asp:Label><br /></ItemTemplate>
</asp:Repeater>
<asp:Repeater ID="rpt_pager" runat="server">
<ItemTemplate>
<a href="paging2.aspx?Page_Number=<%# Container.DataItem %>" style="text-decoration:none;" > <%# Container.DataItem %> </a>
</ItemTemplate>
</asp:Repeater>
as you can see I show page numbers in <a> tag in a repeater
how can I Distinguish selected page number?
Thanks