主题：强制刷新问题

你的意思是要填充有数据的列，没有数据的列就不填充？

如果这样：

If DataTables("出库").datarows.count < 1 Then
    messagebox.show("表中数据为空!")
Else
    Dim dr1 As DataRow
    Dim dt As DataTable = DataTables("出库")
    Dim r As Integer
    r = Tables("商品出库").FindRow("[出库日期] Is null", 0 , False ) '从当前行开始查找
    If r >= 0 Then '如果找到的话
        Tables("商品出库").Position = r '定位到找到的行.
        For Each dr As DataRow In dt.datarows
            dr1 = DataTables("商品出库").DataRows(r)
            For Each dc As DataCol In dt.datacols
                If dr.IsNull(dc.name) = False
                    dr1(dc.name) = dr(dc.name)
                End If
            Next
        Next
    Else
        For Each dr As DataRow In dt.datarows
            dr1 = DataTables("商品出库").DataRows.addnew()
            For Each dc As DataCol In dt.datacols
                If dr.IsNull(dc.name) = False
                    dr1(dc.name) = dr(dc.name)
                End If
            Next
        Next
    End If
    DataTables("商品出库").save()
    DataTables("出库").DataRows.Clear() '清除所有行
    DataTables("商品出库").DataCols("单价").RaiseDataColChanged()
    e.Form.Close()
End If

搞不懂你说的意思。

而且最好不要这么设计，直接在商品入库表输入即可，输入错误后，可以撤销和删除啊。

再说了，临时表输入数据后，需要转入到正是的数据表，关RaiseDataColChanged什么事？

直接：

http://www.foxtable.com/help/topics/1533.htm

按道理填充数据就会触发DataColChanged事件，最好仔细i检查一下代码。

如果搞不定，就将就下面的思路来处理吧：

Dim cnt As integer = DataTables("商品入库").DataRows.Count
填充数据到商品入库表
For i as integer = cnt To DataTables("商品入库").DataRows.Count - 1
     Dim dr As Datarow = DataTables("商品入库").DataRows(i)
     DataTables("商品入库").DataCols("单价").RaiseDataColChanged()
Next 
 

If DataTables("商品出库").DataCols.Contains(dc.Name) = False Then

End If

你11楼的有两个地方用到，都改一下。

If DataTables("出库").datarows.count < 1 Then
    messagebox.show("表中数据为空!")
Else
    Dim dr1 As DataRow
    Dim dt As DataTable = DataTables("出库")
    Dim r As Integer
    r = Tables("商品出库").FindRow("[出库日期] Is null", 0 , False ) '从当前行开始查找
    If r >= 0 Then '如果找到的话
        Tables("商品出库").Position = r '定位到找到的行.
        For Each dr As DataRow In dt.datarows
            dr1 = DataTables("商品出库").DataRows(r)
            For Each dc As DataCol In dt.datacols
                If DataTables("商品出库").DataCols.Contains(dc.name) Then
                    If dr.IsNull(dc.name) = False
                        dr1(dc.name) = dr(dc.name)
                    End If
                End If
            Next
        Next
    Else
        For Each dr As DataRow In dt.datarows
            dr1 = DataTables("商品出库").DataRows.addnew()
            For Each dc As DataCol In dt.datacols
                If DataTables("商品出库").DataCols.Contains(dc.name) Then
                    If dr.IsNull(dc.name) = False
                        dr1(dc.name) = dr(dc.name)
                    End If
                End If
            Next
        Next
    End If
    DataTables("商品出库").save()
    DataTables("出库").DataRows.Clear() '清除所有行
    DataTables("商品出库").DataCols("单价").RaiseDataColChanged()
    e.Form.Close()
End If