protected void CityDD_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds1 = new DataSet(); AreaDD.Items.Clear(); SpecialTiffinRptr.DataSource = ""; SpecialTiffinRptr.DataBind(); InfoLbl.Text = ""; if (CityDD.SelectedIndex == 0) { AreaDD.Items.Clear(); SpecialTiffinRptr.DataSource = ""; SpecialTiffinRptr.DataBind(); InfoLbl.Text = ""; } else { string s = "select area from delivery_area where city='" + CityDD.Text + "'"; ds1 = dc.getdata(s); AreaDD.DataSource = ds1; AreaDD.DataTextField = "area"; AreaDD.DataBind(); AreaDD.Items.Insert(0, "--To Select--"); } }
protected void GoBtn_Click(object sender, EventArgs e) { if(CityDD.SelectedIndex!=0) { if(AreaDD.SelectedIndex!=0) { string jk = "select * from specialtiffin where ProviderCity='" + CityDD.Text + "' and IsAvailable=1"; DataSet dsjk = new DataSet(); dsjk = dc.getdata(jk); if (dsjk.Tables[0].Rows.Count == 0) { SpecialTiffinRptr.DataSource = ""; SpecialTiffinRptr.DataBind(); InfoLbl.Text = "No Special Tiffin Available"; } else { SpecialTiffinRptr.DataSource = dsjk; SpecialTiffinRptr.DataBind(); InfoLbl.Text = "List Of Special Tiffin"; } } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Please Select Your Delivery Area');", true); } } else { ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('Please Select Your City');", true); } }
protected void AreaDD_SelectedIndexChanged(object sender, EventArgs e) { SpecialTiffinRptr.DataSource = ""; SpecialTiffinRptr.DataBind(); InfoLbl.Text = ""; if (AreaDD.SelectedIndex == 0) { SpecialTiffinRptr.DataSource = ""; SpecialTiffinRptr.DataBind(); InfoLbl.Text = ""; } }