请教:我在用DataGrid修改信息时,用e.Item.Cells(3).Controls(0)获取到的始终是修改前的值,而不是修改后的值,导致Update无法修改记录,代码如下:
Private Sub DataGrid1_UpdateCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Dim Tuser, Tpw, Tpr As TextBox
Tuser = e.Item.Cells(3).Controls(0)
Tpw = e.Item.Cells(4).Controls(0)
Tpr = e.Item.Cells(5).Controls(0)
Dim Sql As String
Sql = "update zw_user set username='" & Tuser.Text & "',userpw='" & Tpw.Text & "',userpower='" & Tpr.Text & "' where userid=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex))
Dim Cmd As New OleDbCommand(Sql, Con)
Con.Open()
Cmd.ExecuteNonQuery()
Con.Close()
DataGrid1.EditItemIndex = -1
Call BindData()
End Sub 感谢!感谢!
Private Sub DataGrid1_UpdateCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Dim Tuser, Tpw, Tpr As TextBox
Tuser = e.Item.Cells(3).Controls(0)
Tpw = e.Item.Cells(4).Controls(0)
Tpr = e.Item.Cells(5).Controls(0)
Dim Sql As String
Sql = "update zw_user set username='" & Tuser.Text & "',userpw='" & Tpw.Text & "',userpower='" & Tpr.Text & "' where userid=" & DataGrid1.DataKeys(CInt(e.Item.ItemIndex))
Dim Cmd As New OleDbCommand(Sql, Con)
Con.Open()
Cmd.ExecuteNonQuery()
Con.Close()
DataGrid1.EditItemIndex = -1
Call BindData()
End Sub 感谢!感谢!
if (!IsPostBack){BindData}里面
改成vb就ok
BindData()
End If