Web Forms :: Passing Numeric Checkbox Values Into A Select Statement?

For efficiency's sake I've created a number of stored procedures to run against an SQL table. Which procedure runs depends upon the checkboxlist choices a user makes before clicking a button. The checkboxlist looks something like this:

<asp:CheckBoxList AutoPostBack="True" runat="server">

<asp:ListItem Enabled="True" Value="1">Item 1</asp:ListItem>

<asp:ListItem Value="10"> Item 2</asp:ListItem>

What I can't figure out is how to loop through the checkboxes in the Button1_Click event in the .cs code behind page to add up the values of the selected items. (The value of an unclicked box being 0.) Converted to a string, the totaled value is then appended to a stored procedure name (MyPROC) for entry into the SQL statement. In other words, if the user clicks just Item 1, then the Button1_Click event would produce a stored procedure name of MyPROC1, insert it into the statement, and fire off the query; if Item 1 and Item 3 are selected, then MyPROC101 would be called.

My second question is: how do I place the concatenated string into the SQL statement?

This might all seem a bit unorthodox, but given the number of variables going into statement, it seems to this newbie the best approach.