how to display gridview based only particular name from one table

hi, how can i display my table (one sql table)say i have 10 list of products in "houseware" category and the other 10 list is "food" catergory..

so i have 20 list in my table but only want to show only one category at one time using dropdownlist to activate one category at a time. also i want to display them using multiview component available in asp.net toolbox.. i'm using c# langguage.. thanx in advance..