如何根据复选框插入记录数？ [英] How do I insert number of records based on checkbox?

问题描述

我有skillID字段，这是一个复选框，其值来自tblSkills。如果用户检查skillID字段中的两个复选框，则会在tblConstituentSkills中插入两条记录。



我也试过这段代码：

I have skillID field which is a checkbox where values are from tblSkills. If the user checks two checkbox in skillID field, two records will be insert in tblConstituentSkills.

I also tried this code:

For Each id As Object In skillID.ToString.Split(",")
     Using sql As New SqlProcedure("spInsertSkill")
         sql.AddParameter("@ConstituentIdNo", constituentIdNo)
         sql.AddParameter("@skillID", skillID)
         sql.ExecuteNonQuery()
     End Using
 Next

但它只插入一条记录，在skillID字段中插入的值为id1，id2。

我急需解决它尽快。谢谢你的帮助。



我的尝试：



我尝试过这段代码：

but it only inserts one record and the value inserted in skillID field is "id1,id2".
I badly needed to solve it as soon as possible. Thanks for your help.

What I have tried:

I have tried this code:

Dim varSkillID() As String = Split(skillID, ",")
Dim sql As String = String.Empty
For i As Integer = 0 To varSkillID.Length - 1
    If varSkillID(i) <> "" Then
        sql = "INSERT INTO tblConstituentSkills (ConstituentIdNo,    skillID) VALUES (" & constituentIdNo & ", " & varSkillID(i) & ")"

    End If
Next i

但它不会插入任何内容。

but it does not inserts anything.

推荐答案

你在哪里得到的成分没有??
但你可以用某种方式使用这个代码。



For Each i in skillID.CheckedItems

使用sql作为新的SqlProcedure（spInsertSkill）

sql.AddParameter（@ ConstituentIdNo，constituentIdNo ）

sql.AddParameter（@ skillID，itm.Tostring）

sql.ExecuteNonQuery（）

结束使用

下一步

where do you get the constituentNo ??
but u can use this code somehow.

For Each i In skillID.CheckedItems
Using sql As New SqlProcedure("spInsertSkill")
sql.AddParameter("@ConstituentIdNo", constituentIdNo)
sql.AddParameter("@skillID", itm.Tostring)
sql.ExecuteNonQuery()
End Using
Next

我刚看完这篇文章并救了我。 将逗号分隔值分开并存储在sql表中服务器 - 堆栈溢出 [ ^ ]

I just read this article and saved me. separate comma separated values and store in table in sql server - Stack Overflow[^]

这篇关于如何根据复选框插入记录数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！