如果是一个月份一行,需要一行插入一次,多次执行sql,比如
cmd.Commandtext = "Insert Into 党费缴纳 (党员编号,姓名,缴费年度,月份,金额,收款时间,收款人) values ('" & bh & "','" & xm & "','" & nd & "','一月','" & e.form.controls("ye").text & "','" & sksj & "','" & skr & "')"
cmd.ExecuteNonQuery()
cmd.Commandtext = "Insert Into 党费缴纳 (党员编号,姓名,缴费年度,月份,金额,收款时间,收款人) values ('" & bh & "','" & xm & "','" & nd & "','二月','" & e.form.controls("ey").text & "','" & sksj & "','" & skr & "')"
cmd.ExecuteNonQuery()
……