i am storing multiple values through a listbox to database column. Now in my column values are like this : 21,34,12,
i have a seperate table for these values like 21 is food, 34 is fuel, 12 is education.
now i want to show these all values on one repeater label seperated by ',' like this food,fuel,education.
Previously i am storing only one value and according to it i am fetching its corresponding value from other table on a label. Code i am using is:
select r.*, sc.subcategory_name from tbl_adregister r join tbl_subcategory as sc on r.subcategory=sc.subcategory_id
<asp:Label ID="lbl_subcategory" runat="server" Text='<%#Eval("subcategory_name")%>'></asp:Label>
subcategory column value: 21
Result: Food
Now i want to show like this...
subcategory column value: 21,34,12,
Result: Food,Fuel,Education