Hi
You need to filter the values according to the selection of values right.
If i am right, See this following example.
I have done like this, i used to concatenate the query values according to the selection.
The values will get filtered and it will be displayed on the gridview.
For example:
If you have dropdownlist for organisation,department,division,etc., you need to filter the values according to these selection.
Design page:
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="ddlOrganisation" runat="server"
onselectedindexchanged="ddlOrganisation_SelectedIndexChanged">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Organisation</asp:ListItem>
<asp:ListItem>Org</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ddlDepartment" runat="server"
onselectedindexchanged="ddlDepartment_SelectedIndexChanged">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Software</asp:ListItem>
<asp:ListItem>Networking</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ddlLocation" runat="server"
onselectedindexchanged="ddlLocation_SelectedIndexChanged">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Chennai</asp:ListItem>
<asp:ListItem>Hydrebad</asp:ListItem>
</asp:DropDownList>
</div>
</form>
</body>
.CS Page:
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
PopulateValues();
}
protected void ddlOrganisation_SelectedIndexChanged(object sender, EventArgs e)
{
PopulateValues();
}
protected void ddlDepartment_SelectedIndexChanged(object sender, EventArgs e)
{
PopulateValues();
}
protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
{
PopulateValues();
}
protected void PopulateValues()
{
string Query = "Select * from tablename where empresignedstatus ='No'";
if(ddlDepartment.SelectedItem.Text !="Select")
Query += "and Department='"+ ddlDepartment.SelectedItem.Value+"'";
if(ddlOrganisation.SelectedItem.Text != "Select")
Query += "and Organisation='" + ddlOrganisation.SelectedItem.Value + "'";
if (ddlLocation.SelectedItem.Text != "Select")
Query += "and Location='" + ddlLocation.SelectedItem.Value + "'";
//Here write the SQL Execution coding.
}
}
If you have not selected any values from the dropdownlist, Values will not be filtered ..
If you have chosen any values on any one of the dropdown the values will be filtered according to the selection
Display those values where you need..
Let me know, if you have any queries
Thanks & Regards,
Santhi .V
Rock_Monu, if this helps please login to Mark As Answer. | Alert Moderator