Unable to store selected value in database

See more:

C#

ASP.NET

C#4.0

SQL-Server-2012

Hi


I need a help I create a checkbox list in asp.net in checkbox list i show the name from the table and i want to store the Id of that name in different table and I dont want to show the value to user in textbox

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
            <ContentTemplate>

                <asp:TextBox ID="TextBox1" TextMode="MultiLine" runat="server"></asp:TextBox>
                <asp:Panel ID="Panel1" runat="server">
                    <asp:CheckBoxList ID="CheckBoxList1" OnSelectedIndexChanged="CheckBoxList1_SelectedIndexChanged" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="Name" DataValueField="Test_Id"></asp:CheckBoxList>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Test %>" SelectCommand="SELECT * FROM [test2]"></asp:SqlDataSource>
        </asp:Panel>
                  </ContentTemplate>
        </asp:UpdatePanel>

protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)
   {

       for (int i = 0; i < CheckBoxList1.Items.Count; i++)
       {
           if (CheckBoxList1.Items[i].Selected)
           {
               name += CheckBoxList1.Items[i].Value + ",";

           }
           TextBox1.Text = name;
       }

   }


protected void Button2_Click(object sender, EventArgs e)
   {
       bool n = false;
       string Name = "test";
       byte Test_Id = Convert.ToByte(TextBox1.Text);
       byte Id = 0;
       tt.Order_By_Test1(ref Connection_string, out Id);
       Id = Convert.ToByte(Id + 1);
       tt.Insert_Test1(ref Connection_string, ref Id, ref Name, ref Test_Id, out n);

   }