protected void ddlSearchCategory_SelectedIndexChanged(object sender, EventArgs e) { if (ddlSearchCategory.SelectedItem.Text != "Select") { // Bind the search category value in second ddl DataTable ds = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchDetailBySearchCategory(ddlSearchCategory.SelectedItem.Text); ddlSearchCategory1.DataSource = ds; if (ddlSearchCategory.SelectedItem.Text == "Religion") { ddlSearchCategory1.DataTextField = "ReligionName"; ddlSearchCategory1.DataValueField = "ReligionID"; } else if (ddlSearchCategory.SelectedItem.Text == "Spot Category") { ddlSearchCategory1.DataTextField = "SpotCategoryName"; ddlSearchCategory1.DataValueField = "SpotCategoryID"; } ddlSearchCategory1.DataBind(); ddlSearchCategory1.Items.Insert(0, "Select"); //End Bind the search category value in second ddl } else { ddlSearchCategory1.Items.Clear(); ddlSearchCategory1.Items.Add("Select"); // fetch value of the grid details.... DataSet fetchspotdetails = new DataSet(); SpotDetailsBAL det = new SpotDetailsBAL(); fetchspotdetails = det.FetchSpotDetails(); grdSpotName.DataSource = fetchspotdetails.Tables[4]; grdSpotName.DataBind(); //End value of the grid details.... } }
protected void ddlSearchCategory_SelectedIndexChanged(object sender, EventArgs e) { if (ddlSearchCategory.SelectedItem.Text != "Select") { // Bind the search category value in second ddl DataTable ds = new DataTable(); GeneralBAL lp = new GeneralBAL(); ds = lp.FetchDetailBySearchCategory(ddlSearchCategory.SelectedItem.Text); ddlSearchCategory1.DataSource = ds; if (ddlSearchCategory.SelectedItem.Text == "Religion") { ddlSearchCategory1.DataTextField = "ReligionName"; ddlSearchCategory1.DataValueField = "ReligionID"; } else if (ddlSearchCategory.SelectedItem.Text == "Spot Category") { ddlSearchCategory1.DataTextField = "SpotCategoryName"; ddlSearchCategory1.DataValueField = "SpotCategoryID"; } ddlSearchCategory1.DataBind(); ddlSearchCategory1.Items.Insert(0, "Select"); //End Bind the search category value in second ddl } else { ddlSearchCategory1.Items.Clear(); ddlSearchCategory1.Items.Add("Select"); // fetch value of the grid details.... DataSet fetchspotdetails = new DataSet(); SpotDetailsBAL det = new SpotDetailsBAL(); fetchspotdetails = det.FetchSpotDetails(); grdSpotName.DataSource = fetchspotdetails.Tables[4]; grdSpotName.DataBind(); //End first value of the grid details.... } }