接上面的复选框,如我想把复选框内表A新的数据更新合并导入过来,下面的代码怎么加工到一块?
Dim ckl As WinForm.CheckedListBox = e.Form.Controls("CheckedListBox1")
Dim nms As New List(Of String)
For i As Integer = 0 To ckl.Items.count - 1
If ckl.GetItemChecked(i) Then
nms.Add(ckl.Items(i))
End If
合并导入:
If CurrentTable.DataTable.Name = "表A" Then
Dim Result As DialogResult
Result = MessageBox.Show("请注意,你的数据将要先全部清除,清除后再导入新的数据,现在开始吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question)
If Result = DialogResult.Yes Then
DataTables("表A").DataRows.Clear
MessageBox.Show("数据已全部清除,现在开始导入新数据?", "提示")
Syscmd.Table.QuickMerge()
MessageBox.Show("数据已导入,请注意保存。", "提示")
Else
MessageBox.Show("数据未导入,请重新操作。", "提示")
End If
End If
for each n as string in nms
Dim mg As New Merger
mg.SourcePath = "c:\data\" & n & ".xls"
mg.Format = "excel" '指定格式
mg.SourceTableName = n & "$ '指定要合并的表
mg.DataTableName = n '指定接收数据的表
mg.Merge() '开始合并
next