Hi,

I have a confirmation page for entered records where a user can edit incorrect entries. One of those controls is a listbox, and on the original record entry the user can make multiple selections in this listbox.

My question is, on my edit page, how can I set the multiple selections chosen on the original record save as selected? I know how to populate the listbox with all available selections, and I would get the selections the user made from a stored procedure into my page (SELECT listItemVal FROM table WHERE registrationID = @registrationID). I just don't know how to loop through the listbox populated with all values and set the items whose values are equal to the selected items from my stored procedure = true.

Can someone please offer some advice?

Thanks,

John

Hi Jtyson,

Use the below code snippet to solve your problem. Here ObjDr is a SqlDataReader and lstCourse is the name of my ListBox.

while (ObjDr.Read())
{
  foreach(ListItem LI in lstCourse.Items)
   {
    if(LI.Value.ToString() == ObjDr["YourFieldName"].ToString())
      {
    LI.Selected = true;
      }
   }
}

Hope this suffices your need!!

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.blogspot.com