protected void BindRepeaterData() { DALSchedule objDAL = new DALSchedule(); DataTable dt = objDAL.GetFranchiseeList(""); RepSample.DataSource = dt; RepSample.DataBind(); objDAL = null; dt = null; }
protected void ddlFranCity_SelectedIndexChanged(object sender, EventArgs e) { DALSchedule objDAL = new DALSchedule(); DataTable dt = null; if (ddlFranCity.SelectedItem.Text.ToString() == "-------Select--------") { dt = objDAL.GetFranchiseeList(""); } else { dt = objDAL.GetFranchiseeList(ddlFranCity.SelectedItem.Text.ToString()); } RepSample.DataSource = dt; RepSample.DataBind(); objDAL = null; dt = null; }