Filtering SqlDataSource with multiple dropdownlists

Question

I have an SqlDataSource at the moment, which I want to be able to be filtered using 3 DropDownList's. Basically, each DropDownList contains values for a certain column on the table, so when they choose one of the values, the SqlDataSource only shows values with that value in the relevant column.

So my table is somewhat like this:

ID (primary key)

ManufacturerID

ItemTypeID

UnitTypeID

And the 3 DropDownList's contain the following:

Manufacturers (value = ManufacturerID)

ItemTypes (value = ItemTypeID)

UnitTypes (value = UnitTypeID)

My filter expression for the datasource is currently like this, but it doesn't seem to work unless all 3 boxes have a value selected, which is not ideal. Any ideas guys? My filterexpression is below:

ItemTypeID = {0} OR ManufacturerID = {1} OR UnitTypeID = {2} OR (ItemTypeID = {0} AND ManufacturerID = {1}) OR (ItemTypeID = {1} AND UnitTypeID = {2}) OR (ManufacturerID = {1} AND UnitTypeID = {2}) OR (ItemTypeID = {0} AND ManufacturerID = {1} AND UnitTypeID = {2})

Homam · Accepted Answer · 2011-02-04 16:02:32Z

1

You can add the filter criteria one by one like the following:

// Idea not code..

yourFilterExpression = "";
if (dropDownList1.SelectedValue != null)
 filterExpression = // filter expression 1
if (dropDownList2.SelectedValue != null)
 filterExpression += // filter expression 2

Good luck!

answered Feb 4, 2011 at 16:02

Homam

23.9k37 gold badges121 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filtering SqlDataSource with multiple dropdownlists

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related