i have a repeater which shows the list of categories ( which i have in database ) , i have another repeater inside this repeater which shows the items related to the category from my db, the category repeater works fine , but this is what i want to do :
category1=>item1_category1, item2_category1, item3_category1 , ....
category2=>item1_category2, item2_category2, item3_category2, ....
........
as i said , there is no problem in category list, but i dont know what should i do for the items list.
in a normal situation if i want to use a sql command i should use " select item from db where category=@category" but in this situation @category changes through the repeater( category repeater)
any idea ?!!!!!!!
thanks in advance