代码没有错,请注意细节,你比较的表是什么,你接收的表是什么。
Dim jsmc As WinForm.ComboBox = e.Form.Controls("竞赛名称")
Dim xzb As WinForm.ComboBox = e.Form.Controls("选择表")
Dim xm As WinForm.ComboBox = e.Form.Controls("项目")
Dim dt As DataTable = DataTables(""& xzb.text & "")
Dim dt1 As DataTable = DataTables("报名表")
Dim dr,fr As DataRow
Dim Ary As String()
For Each Ary In dt1.GetUniqueValues("竞赛名称='" & jsmc.text & "' And 参赛项目 like '*" & xm.Text & "*'","编号","中小学","学校","姓名","场地","参赛项目","竞赛名称")
Dim flt As String = "编号 = '" & ary(0) & "' And 竞赛名称 = '" & ary(6) & "'"
If dt.Find(flt) Is Nothing Then
dr = dt.AddNew
dr("编号") = Ary(0)
dr("中小学") = Ary(1)
dr("学校") = Ary(2)
dr("姓名") = Ary(3)
dr("场地") = Ary(4)
dr("参赛项目") = Ary(5)
dr("竞赛名称") = Ary(6)
End If
Next
DataTables(""& xzb.text & "").AllowEdit = False
[此贴子已经被作者于2013-1-24 15:02:34编辑过]