using System;
using System.Configuration;
using System.Collections.Generic;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ncTools;

public partial class TestPaging : System.Web.UI.Page
{
    private oMyODBC oDB = new oMyODBC();
    private string strConn = ConfigurationManager.ConnectionStrings["sqldb2_ConnectionString"].ToString();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.ctrlPg.btnFirstRow.Command += btnFirstRow_Click;
        this.ctrlPg.btnPrevious.Command += btnPrev_Click;
        this.ctrlPg.btnNext.Command += btnNext_Click;
        this.ctrlPg.btnLastRow.Command += btnLastRow_Click;
        LoadRepeaterDataListing();
    }
    protected void LoadRepeaterDataListing()
    {
        this.ctrlPg.PagingSize = 25;
        this.ctrlPg.LoadPageDataSource(LoadDataListing());
        this.ctrlPg.lblPagingMessage.Text = this.ctrlPg.PagingMessage;
               
        rptList.DataSource = this.ctrlPg.Paging_DataSource;
        rptList.DataBind();
    }
    private DataTable LoadDataListing()
    {   
        DataView dv = new DataView();
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("city_name"));
        dt.Columns.Add(new DataColumn("state_abbv"));
        dt.Columns.Add(new DataColumn("zipcode"));
        DataRow dr;

        string sTSQL1 = "select cityname,stateabbrv,zipcode from tblzipcodes";
        //-sTSQL1 += "  from tblzipcodes";

        SqlDataReader oRs = oDB.SqlRecordSet(sTSQL1, strConn);

        if (oRs.HasRows ==true)
        {
            if (oRs["cityname"].ToString().Trim() != "System.Data.SqlClient.SqlDataReader")
            {
                dr = dt.NewRow();
                dr["city_name"] = oRs["cityname"].ToString();
                dr["state_abbv"] = oRs["stateabbrv"].ToString();
                dr["zipcode"] = oRs["zipcode"].ToString();
                dt.Rows.Add(dr);
            }
            while (oRs.Read())            
            {
                if (oRs["cityname"].ToString().Trim() != "System.Data.SqlClient.SqlDataReader")
                {
                    dr = dt.NewRow();
                    dr["city_name"] = oRs["cityname"].ToString();
                    dr["state_abbv"] = oRs["stateabbrv"].ToString();
                    dr["zipcode"] = oRs["zipcode"].ToString();
                    dt.Rows.Add(dr);
                }
            }
        }
        oRs.Close();        
        dt.AcceptChanges();
        return dt;
    }
    protected void btnFirstRow_Click(object sender, System.EventArgs e)
    {
        //- Set viewstate variable to the previous page
        ctrlPg.CurrentPage = 0;
        //- Reload control
        LoadRepeaterDataListing();
    }
    protected void btnPrev_Click(object sender, System.EventArgs e)
    {
        //- Set viewstate variable to the previous page
        ctrlPg.CurrentPage -= 1;
        //- Reload control
        LoadRepeaterDataListing();
    }
    protected void btnNext_Click(object sender, System.EventArgs e)
    {
        //- Set viewstate variable to the next page
        ctrlPg.CurrentPage += 1;
        //- Reload control
        LoadRepeaterDataListing();
    }
    protected void btnLastRow_Click(object sender, System.EventArgs e)
    {
        //- Set viewstate variable to the previous page
        ctrlPg.CurrentPage = this.ctrlPg.Paging_DataSource.PageCount-1;
        //- Reload control
        LoadRepeaterDataListing();
    }
}