Listbox Multiple Selection Update Record

[BrendaD]

I have been looking for days on how to perform a - hopefully - simple task.

I have a MultiSelect Listbox on my Insert Page.

<asp:ListBox ID="ddlSite" 		 
		  DataSource="<%# dsSite.DefaultView %>" 
		  DataTextField="Site" 
		  DataValueField="Site"		 
		  Rows="5" 
		  runat="server" 
		  SelectionMode="multiple">
		  </asp:ListBox>

I want to have a MultiSelect Listbox on my Update (Edit) Page that shows which sites were selected on the Insert Page so the User does not need to reselect them, thus eliminating errors and wasting their time.

The 'ddlSite' field in my table (tblRequest) that recieved the inserted data stores the selected values separated by commas (ie: Birchmount,Longview,GlenEden).

How can I show in my Update Page listbox which items were selected on the Insert Page.

I'm working in C#.

TIA, Brenda

 

[link9]

A simple loop will have to do in this case.

Split the comma separated list into an array:

string[] selectedItems = value.Split(',');

Then just iterate over that array, setting the items in the ddl to selected = true:

for(...)
{
ddl.Items.FindByText/Value(selectedItems).Selected = true;
}//for

Something along those lines. I'm not sure how you have your ddl setup w/ text/value, hence my Text/Value up there. Whichever method is appropriate is the one you should use.

-p

The answer to getting answered -- faq855-2992