Link to home
Start Free TrialLog in
Avatar of AlHal2
AlHal2Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Listbox to amend selections

I have a table with the following columns
Ticket Number
Assignee

There is a separate table listing all assignees - something like a list of all the staff.  Each ticket can have multiple assignees.  Assignees can work on multiple tickets.

When the user selects a ticket I want a list box to show total staff with the assignees on that ticket highlighted.  The user should be able to add and remove assignees from a given ticket.  The list of selected assignees need to be passed to an SQL stored procedure.
I'm using C# in Visual Studio 2010.
Avatar of Dustin Saunders
Dustin Saunders
Flag of United States of America image

So I'm not 100% on what you're asking.

Do you need help structuring the tables & creating a bridge table, or how to pull that into a C# DataTable to show in a control?
Avatar of AlHal2

ASKER

The latter.
ASKER CERTIFIED SOLUTION
Avatar of Dustin Saunders
Dustin Saunders
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AlHal2

ASKER

Thanks very much.
I put the entire list in a drop down box and the selected items into the list box.
Users can add items from the drop down box into the list box or select an item in the list box to remove it.
The program loops through the items in the list box and sends the selected text to a stored procedure.