//run change district function protected void ChangeDistrict_Click(object sender, EventArgs e) { try { if (GridView.SelectedIndex == -1) { throw new ValueNotSelectedException(); } else { District.DataSource = CreateDataSourceForDistrict(); District.DataTextField = "StatusName"; District.DataValueField = "StatusValue"; District.DataBind(); District.Visible = true; Confirm.Visible = true; Cancel.Visible = true; } } catch (Exception ex) { FailureText.Text = ex.Message; ErrorMessage.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { District.DataSource = CreateDataSourceForDistrict(); District.DataTextField = "StatusName"; District.DataValueField = "StatusValue"; District.DataBind(); District.Visible = true; } }
protected void Region_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt3 = dh.GetData("GetAllCities", new object[] { Region.SelectedValue.ToString(), Country.SelectedValue.ToString() }); District.DataSource = dt3; District.DataTextField = "name"; District.DataValueField = "id"; District.DataBind(); }
private void FindDistrict(string CitySort) { string cityCode = CitySort; string sql = "select ID,DisName from T_District where CityID='" + cityCode + "'"; SqlConnection conn = new SqlConnection("server=.;database=MarriageAndLove;uid=sa;pwd=conan;"); SqlDataAdapter adapter = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); conn.Open(); adapter.Fill(ds); conn.Close(); District.DataSource = ds.Tables[0]; District.DataValueField = "ID"; District.DataTextField = "DisName"; District.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!HttpContext.Current.User.IsInRole("ADMIN")) { HttpContext.Current.Response.Redirect("Default.aspx"); } else { DataTable dt1 = dh.GetData("GetAllBusinessCategory", null); DataTable dt2 = dh.GetData("GetAllDistricts", null); PCategory.DataSource = dt1; District.DataSource = dt2; /////////////////////////// PCategory.DataTextField = "Name"; PCategory.DataValueField = "ID"; District.DataTextField = "Name"; District.DataValueField = "ID"; District.DataBind(); } } }