select multiple dropdown in VB.Net

Question

Hi, I have created report, now in report i have multiple dropdown where data is coming from database but "ALL" option also i have added.

Report Type	--Select--  Summary Report  Moved Object Report  Maintenance Report  Analysis Report  Warranty Report  Barcode Report  Missing Report	Object Type	ALL  Movable  Immovable	Location	ALL  trichy  Chennai    bangalore	From
Vendor Name	ALL  Lenovo  PHILIPS  Hcl	Object	ALL  Washing1  Oven  Refridgerator  test object	Department	ALL  Electronicsaa  Automobile    test department	To

Now how to give condition if i want to search report data based on "location" or "department" or "vendor name" ... so on  with two conditions if selected value is "ALL" then all details should come or selected value is "value" then based on that data should come from database.

if i ll put if else condition then it ll be many conditions i have to put that i don't want.

I am not getting how to do that.I want help.

If question will not clear please let me know.