这是我的代码,每次我单击Button1时,它不是刷新Datagridview,而是添加另一个与前一个条目重复的条目。我知道我的代码中缺少了在再次加载数据之前清除Datagrid中的数据的内容。请帮帮我..
Private Function LoadData_UnitProcess()
    Dim UP_SQL As String = "SELECT LotNum FROM Transactions WHERE StatusID=3 ORDER BY Process_EntryDate DESC"
    Dim UP_Ad As OleDbDataAdapter = New OleDbDataAdapter(UP_SQL, strCon)
    UP_Ad.Fill(UP_Ds, "Transactions")
    UnitOnProcess_DG.DataSource = UP_Ds.Tables(0)
    With UnitOnProcess_DG
        .RowHeadersVisible = False
        .Columns(0).HeaderCell.Value = "Lot #"
        .Columns(0).Width = "363"
        .AllowUserToAddRows = False
    End With
    LoadData_UnitProcess = ""
End Function
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    LoadData_UnitProcess()
End Sub
Private Sub Displayer_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    LoadData_UnitProcess()
End Sub发布于 2017-01-31 18:54:10
数据集UP_Ds可能是一个属性或字段。您需要在重新填充数据集之前对其进行重置,否则会将内容追加到前一个数据集上。
UP_Ds.Reset()
UP_Ad.Fill(UP_Ds, "Transactions")
UnitOnProcess_DG.DataSource = UP_Ds.Tables(0)https://stackoverflow.com/questions/41950341
复制相似问题