using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using nmsSetup; using System.Data; using System.Data.SqlClient; using nmsDropDown; using System.Collections; public partial class Default2 : System.Web.UI.Page { clsBLSetup b; private int iPageSize = 15; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { bind_State(); } } public void bind_State() { List lst = new List(); clsPRPdropdown prp = new clsPRPdropdown(); clsDLdropDown obj = new clsDLdropDown(); b = new clsBLSetup(); prp.id = 0; prp.spName = "selState"; lst = obj.SelectDropDown(prp); ddlstate.DataSource = lst; ddlstate.DataTextField = "name"; ddlstate.DataValueField = "id"; ddlstate.DataBind(); } public void bind_District(Int32 id) { List lst = new List(); clsPRPdropdown prp = new clsPRPdropdown(); clsDLdropDown obj = new clsDLdropDown(); b = new clsBLSetup(); prp.id = id; prp.spName = "Bind_District"; lst = obj.SelectDropDown(prp); ddlDistrict.DataSource = lst; ddlDistrict.DataTextField = "name"; ddlDistrict.DataValueField = "id"; ddlDistrict.DataBind(); } public void Bind_TC() { Registration obj = new Registration(); b = new clsBLSetup(); obj.Name = txttcname.Text; if (ddlstate.SelectedIndex > 0) obj.State = Convert.ToInt32(ddlstate.SelectedValue); else obj.State = 0; if (ddlDistrict.SelectedIndex > 0) obj.District = Convert.ToInt32(ddlDistrict.SelectedValue); else obj.District = 0; DataTable dt = b.SearchTCenter(obj); PagedDataSource pdsData = new PagedDataSource(); DataView dv = new DataView(dt); pdsData.DataSource = dv; pdsData.AllowPaging = true; pdsData.PageSize = iPageSize; if (ViewState["PageNumber"] != null) pdsData.CurrentPageIndex = Convert.ToInt32(ViewState["PageNumber"]); else pdsData.CurrentPageIndex = 0; if (pdsData.PageCount > 1) { Repeater1.Visible = true; ArrayList alPages = new ArrayList(); for (int i = 1; i <= pdsData.PageCount; i++) alPages.Add((i).ToString()); Repeater2.DataSource = alPages; Repeater2.DataBind(); } else { Repeater2.Visible = false; } //Repeater2.DataSource = pdsData; //Repeater2.DataBind(); if (dt.Rows.Count > 0) { Repeater1.DataSource = pdsData; Repeater1.DataBind(); } else { Repeater1.DataSource = null; Repeater1.DataBind(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "showError", "alert('Record Not Found');", true); } } protected void Button1_Click(object sender, EventArgs e) { Bind_TC(); } protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e) { if (ddlstate.SelectedIndex > 0) bind_District( Convert.ToInt32(ddlstate.SelectedValue)); } protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { ViewState["PageNumber"] = Convert.ToInt32(e.CommandArgument); Bind_TC(); } }