将复选框列表项插入数据库

问题描述

我被困在中间。无法将值插入数据库。你可以帮帮我吗。



提前致谢。



我的代码是：

c＃

Hi,

I was stuck in middle. Was not able to insert values into the DB. Could u please help me out.

Thanks in advance.

My code is:
c#

public void savetoDB()
       {
           con1.Open();
           string qry = null;
           string inputvalue = null;
           int i = 0;
           for (i = 0; i <= CheckBoxList2.Items.Count - 1; i++)
           {
               if (CheckBoxList2.Items[i].Selected == true)
               {
                   inputvalue = CheckBoxList2.Items[i].Text;
                   qry = "INSERT INTO DART_IDC_ADD_PROC_MAP(DAR_ID,ADD_PROC_SEL) VALUES (123,'" + inputvalue + "')";
                   SqlCommand cmd = new SqlCommand(qry, con1);
                   cmd.ExecuteNonQuery();
               }

           }
           con1.Close();

       }

ASP代码：

ASP Code:

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

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

          <asp:CheckBoxList ID="CheckBoxList2" runat="server" AppendDataBoundItems="True"

              EnableViewState="False">
          </asp:CheckBoxList>
          </ContentTemplate>
          </asp:UpdatePanel>

      <br />
      <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
      <br />

推荐答案

这篇关于将复选框列表项插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！