AlHal2
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.
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.
ASKER
The latter.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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?