I have multiple comboBoxes all with checkboxes. What I want to do is pass the checkedItems (multiple) of a comboBox as a parameter value for a stored procedure.
The way the stored procedure is built, having a separator of "+" would work when more than one checkbox is checked. (I have Display All Input set to true). However the separator by default is ",".
Is there any way of changing the separator that appears when more than one checkbox is checked within a comboBox?
If not, how do I append a "+" sign onto the end of each item when it is checked, basically it would be to convert the checkedItems to a "+" delimited list and send them as parameters that way.
cmd.Parameter.AddWithValue("@ID_SYSTEM", ID_SYSTEM);
I want to be able to pass more than just one instance of @ID_SYSTEM as a parameter value for a stored procedure.
The way the stored procedure is built, having a separator of "+" would work when more than one checkbox is checked. (I have Display All Input set to true). However the separator by default is ",".
Is there any way of changing the separator that appears when more than one checkbox is checked within a comboBox?
If not, how do I append a "+" sign onto the end of each item when it is checked, basically it would be to convert the checkedItems to a "+" delimited list and send them as parameters that way.
cmd.Parameter.AddWithValue("@ID_SYSTEM", ID_SYSTEM);
I want to be able to pass more than just one instance of @ID_SYSTEM as a parameter value for a stored procedure.