//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();
}
}
}
