Paging with out using data pager

 protected void Page_Load(object sender, EventArgs e)
    {

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

        SqlConnection con = new SqlConnection("server=.\\SQLEXPRESS; database=coolX; Integrated Security=True;");
        con.Open();

        SqlCommand cmd = new SqlCommand("select count(*) from pagingTable", con);

        SqlDataReader dr;
        dr = cmd.ExecuteReader();

        int i = 0;

        if (dr.HasRows)
        {
            dr.Read();
            if (dr[0] != null)
            {
                try
                {
                  i = Convert.ToInt32(dr[0].ToString());

                  Label1.Text = "Records count :: " + i.ToString() + "<br><br><br><br>";
                }
                catch
                {
                    Label1.Text = "0 count <br>";
                }
            }
        }
        con.Close();
      
//SELECT  Description, Date
//FROM     (SELECT  ROW_NUMBER() OVER (ORDER BY Date DESC)
//             AS Row, Description, Date FROM LOG
//          )
//AS LogWithRowNumbers
//
//WHERE  Row >= 11 AND Row <= 20

        SqlDataAdapter ada = new SqlDataAdapter();
        if (Request.QueryString["pgno"] != null)
        {
            try
            {

                int ty = Convert.ToInt32(Request.QueryString["pgno"].ToString());

                int stop = Convert.ToInt32(Request.QueryString["pgno"].ToString()) * 5;

                ada =
                new SqlDataAdapter
  (@"SELECT sno, coolMessage
   FROM
   ( SELECT ROW_NUMBER() OVER( order by sno asc) AS Row, sno, coolMessage FROM pagingTable )
   AS LogWithRowNumbers
   WHERE Row >= " + ( stop - 4 ) + @" AND Row <= " +( stop ) + @" 
 ",
                con);
            }
            catch
            {
            }
        }
        else
        {
            ada =
               new SqlDataAdapter
  (@"SELECT sno, coolMessage
   FROM
   ( SELECT ROW_NUMBER() over( order by sno asc) AS Row, sno, coolMessage FROM pagingTable )
   AS LogWithRowNumbers
   WHERE Row >= 1 AND Row <= 5"
  ,
   con);
        }

DataSet ds = new DataSet();
ada.Fill(ds, "nikah");

for (int t = 0; t < ds.Tables["nikah"].Rows.Count; t++)
{
    Label1.Text += ds.Tables["nikah"].Rows[t][0].ToString() + " " + ds.Tables["nikah"].Rows[t][1].ToString() + "<br>";
}

        for (int x = 0; x < i/5; x++)
        {
            LiteralControl lnk = new LiteralControl("<a href=\"Default.aspx?pgno=" + (x+1) + "\">" + (x+1) + "</a>");
            paging.Controls.Add(lnk);

            LiteralControl l = new LiteralControl("&nbsp;");
            paging.Controls.Add(l);

            int lastx = x ;

            if (++lastx >= i / 5)
            {
                int last = i % 5;
                if (last == 0)
                {

                }
                else
                {
                    LiteralControl lnklast = new LiteralControl("<a href=\"Default.aspx?pgno=" + (lastx + 1) + "\">" + (lastx + 1) + "</a>");
                    paging.Controls.Add(lnklast);

                    LiteralControl llast = new LiteralControl("&nbsp;");
                    paging.Controls.Add(llast);
                }

            }

        }

   /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////    

    }