各位老师,我在表的DataRowDeleting事件中加入以下代码,可实现删除行后并将数据自动填充到指定表中,但是前提是指定的表必需是已加载的表,如何能实现将其填充到未加载的表中呢,这样以后需要加载时再加载查看。
Dim Cols1() As String = {"成品料号", "项目编号", "模具类型", "供应商", "厂商模号", "开模日期", "报废人", "客户料号", "客户名称", "模具编号", "报废日期", "归属部门", "模次", "单价"}
Dim Cols2() As String = {"成品料号", "项目编号", "模具类型", "供应商", "厂商模号", "开模日期", "报废人", "客户料号", "客户名称", "模具编号", "报废日期", "归属部门", "模次", "单价"}
Dim dr2 As DataRow = DataTables("报废模具清单").AddNew()
For i As Integer = 0 To Cols1.Length - 1
dr2(Cols2(i)) = e.DataRow(Cols1(i))
Next
都说了反过来处理咯。把未加载的外部数据表通过SQLcommand加载一个空表,然后填充到空表就行了