Multiple selected Listbox in GridView

[awmb]

Language C#, Version ASP.Net 2.0

Hi

I have a GridView which is bound to a table which contains Restaurant information. In the Edit Row there is a Listbox (ListBox1) in the Food Type column, bound to a table containing the food types.

<EditItemTempla te>
<asp:ListBox ID="ListBox1" runat="server" AppendDataBound Items="True" DataSourceID="F oodTypes"
DataTextField=" FoodType" DataValueField= "FoodType" SelectedValue=' <%# Bind("food_type ") %>'>
<asp:ListItem Value="">(None) </asp:ListItem></asp:ListBox>

<asp:ObjectData Source ID="FoodTypes" runat="server" OldValuesParame terFormatString ="original_{ 0}"
SelectMethod="G etFoodTypes" TypeName="VLAdm inDSTableAdapte rs.tblFOODTYPES TableAdapter">
</asp:ObjectDataS ource>
</EditItemTemplat e>


The problem I'm having is that the SelectedValue property of the ListBox is bound to the food_type column in the Restaurant table, which contains a string of food types separated by commas (not a good idea, I know, but I'm having to work with an inherited database).

If I convert the food_type string into an array how can I use it to select multiple ListItems in the ListBox as it is created? I can't seem to refer to ListBox1 from the page's code behind.

Any ideas?