标题: Vb.net(Win) DataGirdView DataTable There is no current data to access [打印本页] 作者: 资讯王 时间: 2009-9-3 09:35 标题: Vb.net(Win) DataGirdView DataTable There is no current data to access 这个error出现是因为你处理delete方面不当
delete的时候需要用orginal
arrl_Parameters.Add(New SqlParameter("@XX", dataRow("XX", DataRowVersion.Original))) 需要整理什么时候用current,什么时候使用original
arrl_Parameters.Add(New SqlParameter("@XX", dataRow("XX", DataRowVersion.Current)))
Insert时可以使用current
If xRow.RowState = DataRowState.Added Then
arrl_Parameters.Add(New SqlParameter("@XX", dataRow("XX", DataRowVersion.Current)))
Update时可以使用original,当ID不能更改
ElseIf xRow.RowState = DataRowState.Modified Then
arrl_Parameters.Add(New SqlParameter("@XX", dataRow("XX", DataRowVersion.Original)))
Delete时肯定要用original
ElseIf xRow.RowState = DataRowState.Deleted Then
arrl_Parameters.Add(New SqlParameter("@XX", dataRow("XX", DataRowVersion.Original)))