protected void Ddl_il_SelectedIndexChanged(object sender, EventArgs e) { Ddl_ilce.DataSource = sc("select c.* from ilceler c inner join iller i on c.sehir = i.id where i.id = '" + Ddl_il.SelectedValue + "'", "ConnStr"); Ddl_ilce.DataTextField = "ilce"; Ddl_ilce.DataValueField = "id"; Ddl_ilce.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["PRS_ID"] == null || Session["Yetki"].ToString() != "1") { Response.Redirect("login.aspx"); } else { listele(); //Ddl_mt.DataSource = sc("select * from MusteriTip", "ConnStr"); //Ddl_mt.DataTextField = "Tip"; //Ddl_mt.DataValueField = "MT_ID"; //Ddl_mt.DataBind(); Ddl_il.DataSource = sc("select *from iller", "ConnStr"); Ddl_il.DataTextField = "sehir"; Ddl_il.DataValueField = "id"; Ddl_il.DataBind(); Ddl_ilce.DataSource = sc("select * from ilceler where sehir=1", "ConnStr"); Ddl_ilce.DataTextField = "ilce"; Ddl_ilce.DataValueField = "id"; Ddl_ilce.DataBind(); //DataTable dt = sc("select * from Bolge", "ConnStr"); //Ddl_bolge.DataSource = dt; //Ddl_bolge.DataTextField = Ddl_bolge.DataValueField = "Bolge"; //Ddl_bolge.DataBind(); } //if (Request["i"] != null) //{ // btn_kaydet.Text = "Güncelle"; // btn_ipt.Visible = true; // DataTable dt = sc("select * from Musteri WHERE M_ID=" + Request["i"], "ConnStr"); // if (dt.Rows.Count == 1) // { // txt_adsoyad.Text = dt.Rows[0]["AdSoyad"].ToString(); // txt_tc.Text = dt.Rows[0]["TCNo"].ToString(); // txt_email.Text = dt.Rows[0]["Email"].ToString(); // txt_cep1.Text = dt.Rows[0]["Cep1"].ToString(); // txt_cep2.Text = dt.Rows[0]["Cep2"].ToString(); // Ddl_il.SelectedValue = dt.Rows[0]["Il_Id"].ToString(); // Ddl_ilce.DataSource = sc("select *from ilceler where sehir=" + dt.Rows[0]["Il_Id"].ToString() + "", "ConnStr"); // Ddl_ilce.DataTextField = "ilce"; // Ddl_ilce.DataValueField = "id"; // Ddl_ilce.DataBind(); // Ddl_ilce.SelectedValue = dt.Rows[0]["Ilce_Id"].ToString(); // Ddl_bolge.DataSource = sc("select *from Bolge where Ilce_Id=" + dt.Rows[0]["Ilce_Id"].ToString() + " and Il_Id=" + dt.Rows[0]["Il_Id"].ToString() + "", "ConnStr"); // Ddl_bolge.DataTextField = "Bolge"; // Ddl_bolge.DataValueField = "BLG_ID"; // Ddl_bolge.DataBind(); // Ddl_bolge.SelectedValue = dt.Rows[0]["Blg_Id"].ToString(); ; // // Ddl_bolge.SelectedItem.Text = dt.Rows[0]["Bolge"].ToString(); // txt_adres.Text = dt.Rows[0]["Adres"].ToString(); // Ddl_mt.SelectedValue = dt.Rows[0]["MsTip"].ToString(); // rb_durum.SelectedValue = dt.Rows[0]["Iptal"].ToString(); // listele(); // } //} } }