Click here to Skip to main content
15,300,338 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)

I need a help I create a checkbox list in 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">

                <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>

protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)

       for (int i = 0; i &lt; CheckBoxList1.Items.Count; i++)
           if (CheckBoxList1.Items[i].Selected)
               name += CheckBoxList1.Items[i].Value + &quot;,&quot;;

           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);

Updated 31-Jul-15 10:37am
njammy 30-Jul-15 8:44am
Please can you give me the value of TextBox1.Text after you click Button2_Click? Hit reply to this comment and let me know.
njammy 30-Jul-15 8:49am
Also please use the Improve Question option to explain the current problem you are getting; "Unable to store value" could mean lots of different possible problems, please explain.
ZurdoDev 30-Jul-15 10:28am
Where are you stuck?
Gurpreet Arora Malhotra 3-Aug-15 1:38am
I retrieve value in textbox 1 .text i want to insert the value in database but i unable to do that
ZurdoDev 3-Aug-15 7:40am
Where is the code to save it to the database? I don't see any.
David A. Gray 31-Jul-15 17:33pm
I don't see any obvious reference to a SQL query or stored procedure.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900