Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
Dim title, author As String
Dim key As String = DataGrid1.DataKeys(e.Item.ItemIndex).ToString()
Dim tb As TextBox
tb = CType(e.Item.Cells(2).Controls(0), TextBox)
title = tb.Text
tb = CType(e.Item.Cells(3).Controls(0), TextBox)
author = tb.Text
Dim r As DataSet6.newsRow
r = DataSet61.news.FindBynewsid(key)
r.title = title
r.author = author
OleDbDataAdapter1.Update(DataSet61)
DataGrid1.EditItemIndex = -1
DataGrid1.DataBind()
End Sub
这个更新怎么会出错呢?
出的错误是:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
Dim title, author As String
Dim key As String = DataGrid1.DataKeys(e.Item.ItemIndex).ToString()
Dim tb As TextBox
tb = CType(e.Item.Cells(2).Controls(0), TextBox)
title = tb.Text
tb = CType(e.Item.Cells(3).Controls(0), TextBox)
author = tb.Text
Dim r As DataSet6.newsRow
r = DataSet61.news.FindBynewsid(key)
r.title = title
r.author = author
OleDbDataAdapter1.Update(DataSet61)
DataGrid1.EditItemIndex = -1
DataGrid1.DataBind()
End Sub
这个更新怎么会出错呢?
出的错误是:
Update requires a valid UpdateCommand when passed DataRow collection with modified rows.
OleDbDataAdapter1.Update(DataSet61)