protected void DDLDistrict_SelectedIndexChanged(object sender, EventArgs e) { List <string> ls2 = new List <string>(); ls2.Clear(); ls2.Add("--Select City--"); switch (DDLDistrict.Text) { case "Bangalore": ls2.Add("Garden City"); break; case "Hosur": ls2.Add("Hosur City"); break; case "Kuppam": ls2.Add("Kuppam City"); break; case "Kerala One": ls2.Add("Kerala One City"); break; } DDLCity.DataSource = ls2; DDLCity.DataBind(); }
private void BindCity() { try { DDLCity.Enabled = true; rfvDDLCity.Enabled = true; DDLCity.Items.Clear(); DataSet ds = new DataSet(); int state_id = Convert.ToInt32(DDLProvince.SelectedValue.ToString()); ds = _objBoutility.get_City_State(state_id); if (ds.Tables[0].Rows.Count > 0) { DDLCity.DataSource = ds.Tables[0]; DDLCity.DataTextField = "Name"; DDLCity.DataValueField = "Id"; DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("-- Please Select --", "0")); } else { DDLCity.DataSource = null; DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("-- Please Select --", "0")); } } catch (Exception ex) { lblMsg.Text = _objBoutility.ShowMessage("danger", "error", ex.Message); ExceptionLogging.SendExcepToDB(ex); } }
public void cleanbt1() { TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox10.Text = ""; TextBox11.Text = ""; DataView dvc = (DataView)this.SqlDataSourceCity.Select(new DataSourceSelectArguments()); DataView dvs = (DataView)this.SqlDataSourceAccess.Select(new DataSourceSelectArguments()); DDLCity.Items.Clear(); DDLCity.Items.Add("請選擇縣市"); DDLCity.DataSource = dvc; DDLCity.DataTextField = "city"; DDLCity.DataBind(); DDLAccess.Items.Clear(); DDLAccess.Items.Add("請選擇"); DDLAccess.DataSource = dvs; DDLAccess.DataTextField = "Cols"; DDLAccess.DataBind(); }
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e) { DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLCity.Enabled = true; }
public void BindCity_State() { DDLCity.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLState.SelectedValue.ToString()), "ListCity"); DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("All", "0")); DDLCity.Enabled = true; }
protected void grdBankDetails_RowEditing(object sender, GridViewEditEventArgs e) { try { pnlBank.Visible = false; Panel1.Visible = true; btnsave.Visible = true; filter.Visible = false; txtbankCode.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkCode")).Text; DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state"); DDLstate.DataBind(); DDLstate.Items.Insert(0, new ListItem("--Select State--", "0")); DDLstate.Enabled = true; // pnlBank.Visible = false; Panel1.Visible = true; lblBankId.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankID")).Text; txtbankName.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkName")).Text; txtbDesc.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankdecp")).Text; txtcountry.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcountry")).Text; DDLCity.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcity")).Text; DDLstate.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblstate")).Text; DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString()); DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("--Select City--", "0")); DDLCity.Enabled = true; chekactive.Checked = ((CheckBox)grdBankDetails.Rows[e.NewEditIndex].FindControl("chkactive")).Checked; } catch { } }
protected void DDLState_SelectedIndexChanged(object sender, EventArgs e) { string connetionString; SqlConnection cnn; connetionString = @"Data Source=DESKTOP-NCLVKS1;Initial Catalog=E-Employment ;User ID=sa;Password=allohomora"; String sql; cnn = new SqlConnection(connetionString); SqlCommand command; cnn.Open(); sql = "Select * from City where [State Id] = @stateId"; command = new SqlCommand(sql, cnn); command.Parameters.AddWithValue("@stateId", DDLState.SelectedIndex); SqlDataAdapter sda = new SqlDataAdapter(command); DataTable dt = new DataTable(); sda.Fill(dt); DDLCity.DataSource = dt; DDLCity.DataTextField = "Name"; DDLCity.DataValueField = "Id"; DDLCity.DataBind(); DDLCity.Items.Insert(0, new ListItem("Select", "0".ToString())); cnn.Close(); }
protected void DDLCountry_SelectedIndexChanged(object sender, EventArgs e) { int countID = Convert.ToInt32(DDLCountry.SelectedItem.Value); if (countID > 0) { conn = DB_Connect.GetConnection(); conn.Open(); string query = "Select * from City Where CountryID = " + countID; SqlDataAdapter _sqlda = new SqlDataAdapter(query, conn); DataTable dt = new DataTable(); _sqlda.Fill(dt); DDLCity.DataSource = dt; DDLCity.DataValueField = "CityID"; DDLCity.DataTextField = "CityName"; DDLCity.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["lvl_id"] == null) { Response.Redirect("Default.aspx"); } else { if (Convert.ToInt32(Session["lvl_id"]) < 3) { Response.Redirect("Default.aspx"); } else { if (!IsPostBack) { if (Convert.ToInt32(Session["lvl_id"]) == 3) // if editor //DDL Schools { int sc_id = Convert.ToInt32(Session["sc_id"]); DataSet dsSchools = ch_schoolsSvc.GetSchool(sc_id); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); //DDL Rooms DataSet dsRooms = ch_roomsSvc.GetRooms(Convert.ToInt32(Session["sc_id"])); ddlRooms.DataSource = dsRooms; ddlRooms.DataValueField = "rm_id"; ddlRooms.DataTextField = "rm_name"; ddlRooms.DataBind(); ddlRooms.Items.Add("-בחר כיתה-"); ddlRooms.SelectedIndex = ddlRooms.Items.Count - 1; } else if (Convert.ToInt32(Session["lvl_id"]) >= 4) // if vice_manager and up //DDL Schools { DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; } //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; } } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["usr_id"] == null) { Response.Redirect("Login.aspx"); } else { if (Session["usr_id"].ToString() == "") { Response.Redirect("Login.aspx"); } } int usr_id = Convert.ToInt32(Session["usr_id"]); if (!IsPostBack) { //DDL Schools DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; //DDL Jobs DataSet dsJobs = ch_jobsSvc.GetJobs(); ddlJobs.DataSource = dsJobs; ddlJobs.DataValueField = "job_id"; ddlJobs.DataTextField = "job_name"; ddlJobs.DataBind(); ddlJobs.Items.Add("-בחר תפקיד-"); ddlJobs.SelectedIndex = ddlJobs.Items.Count - 1; DataRow drUser = ch_usersSvc.GetUserById(usr_id); DDLSchools.SelectedValue = drUser["usr.sc_id"].ToString(); txtAddress.Text = drUser["usr_address"].ToString(); DateTextBox.Text = Convert.ToDateTime(drUser["usr_birth_date"].ToString()).ToShortDateString(); DDLCity.SelectedItem.Text = drUser["cty_name"].ToString(); txtEmail.Text = drUser["usr_email"].ToString(); txtFirstName.Text = drUser["usr_first_name"].ToString(); rbtGender.SelectedValue = drUser["usr_gender"].ToString(); txtHomePhone.Text = drUser["usr_home_phone"].ToString(); txtCellphone.Text = drUser["usr_cellphone"].ToString(); txtIdentity.Text = drUser["usr_identity"].ToString(); txtLastName.Text = drUser["usr_last_name"].ToString(); if (ch_usersSvc.GetUsrType(usr_id) == "tch") { DataSet pro = ch_professionsSvc.GetProfessions(); DataSet tch_pro = ch_teachers_professionsSvc.GetProfessionsByTch(usr_id); int i = 0; foreach (DataRow dr_pro in pro.Tables[0].Rows) { ListItem li = new ListItem(dr_pro["pro_name"].ToString(), dr_pro["pro_id"].ToString()); lbProfessions.Items.Add(li); foreach (DataRow dr_tch_pro in tch_pro.Tables[0].Rows) { if (dr_tch_pro["pro_id"].ToString() == dr_pro["pro_id"].ToString()) { li.Selected = true; } } i++; } pnlTch.Visible = true; } if (ch_usersSvc.GetUsrType(usr_id) == "crw") { DataRow drCrew = ch_crewSvc.GetCrw(Convert.ToInt32(Session["usr_id"])); ddlJobs.SelectedValue = drCrew["job_id"].ToString(); pnlCrw.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["lvl_id"] == null) { Response.Redirect("Default.aspx"); } else { if (Convert.ToInt32(Session["lvl_id"]) < 3) { Response.Redirect("Default.aspx"); } else { if (!IsPostBack) { if (Convert.ToInt32(Session["lvl_id"]) == 3) // if editor //DDL Schools { int sc_id = Convert.ToInt32(Session["sc_id"]); DataSet dsSchools = ch_schoolsSvc.GetSchool(sc_id); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; dsSchools.Tables[0].Columns.Add("school", typeof(string), "sc_name + ' - ' + cty_name"); DDLSchools.DataTextField = "school"; DDLSchools.DataBind(); } else if (Convert.ToInt32(Session["lvl_id"]) == 4) // if vice_manager //DDL Schools { DataSet dsSchools = ch_schoolsSvc.GetSchools(); DDLSchools.DataSource = dsSchools; DDLSchools.DataValueField = "sc_id"; DDLSchools.DataTextField = "sc_name"; DDLSchools.DataBind(); DDLSchools.Items.Add("-בחר בית ספר-"); DDLSchools.SelectedIndex = DDLSchools.Items.Count - 1; } else if (Convert.ToInt32(Session["lvl_id"]) >= 5) // if manager and up //DDL Levels { DataSet dsLevels = ch_levelsSvc.GetLevels(); ddlLevels.DataSource = dsLevels; ddlLevels.DataValueField = "lvl_id"; ddlLevels.DataTextField = "lvl_name"; ddlLevels.DataBind(); ddlLevels.Items.Add(new ListItem("-בחר רמה-", "-1")); ddlLevels.SelectedValue = "2"; } //DDL cities Cities.Cities cty = new Cities.Cities(); DDLCity.DataSource = cty.GetCities(); DDLCity.DataTextField = "שם_ישוב"; DDLCity.DataBind(); DDLCity.Items.Add("-בחר עיר-"); DDLCity.SelectedIndex = DDLCity.Items.Count - 1; //DDL Jobs DataSet dsJobs = ch_jobsSvc.GetJobs(); ddlJobs.DataSource = dsJobs; ddlJobs.DataValueField = "job_id"; ddlJobs.DataTextField = "job_name"; ddlJobs.DataBind(); ddlJobs.Items.Add("-בחר תפקיד-"); ddlJobs.SelectedIndex = ddlJobs.Items.Count - 1; } } } }
protected void DDLState_SelectedIndexChanged(object sender, EventArgs e) { List <string> ls = new List <string>(); ls.Clear(); ls.Add("Select City"); switch (DDLState.Text) { case "TamilNadu": ls.Add("Chennai"); ls.Add("Vellore"); ls.Add("Hosur"); break; case "Karnataka": ls.Add("Bangalore"); ls.Add("Mysore"); ls.Add("Glbarga"); ls.Add("Chitradurga"); ls.Add("Bidar"); ls.Add("Shimoga"); ls.Add("Hubli"); ls.Add("Chikkamagaluru"); ls.Add("Hassan"); break; case "Nassarawa": ls.Add("Karau"); ls.Add("Karau Mada"); break; case "Kaduna": ls.Add("Romi"); ls.Add("Television"); ls.Add("Sabon Tasha"); break; case "Abuja": ls.Add("Maraba Yanya"); ls.Add("Airport Road"); ls.Add("Estate Road"); break; case "Lagos": ls.Add("Lag 1"); ls.Add("Lag 2"); break; case "Washington": ls.Add("Washington City"); ls.Add("Wash 2"); break; case "England": ls.Add("Eng 1"); ls.Add("Eng 2"); break; } DDLCity.DataSource = ls; DDLCity.DataBind(); }