為甚麼我不能取到datagrid 單元格的值,黨datagrid 處於編輯狀態時.
我的代碼:
dim txtbox as textbox
dim ts as string
txtbox=ctype(e.item.cells(2).controls(0),textbox)
ts=txtbox.text
為何我取到的值總是原來的值,而不是我修改後的值,謝謝
...全文
1612打赏收藏
datagrid 問題,急 100分送
為甚麼我不能取到datagrid 單元格的值,黨datagrid 處於編輯狀態時. 我的代碼: dim txtbox as textbox dim ts as string txtbox=ctype(e.item.cells(2).controls(0),textbox) ts=txtbox.text 為何我取到的值總是原來的值,而不是我修改後的值,謝謝
Sub gridupdate(ByVal sender As Object, ByVal e As DataGridCommandEventArgs)
Dim txtbox As TextBox
Dim txtvalue As String
Dim mycomm As System.Data.SqlClient.SqlCommand
Dim sqlcomm As String = "update wb_pocl set cl_name=@cl_name where cl_no=@cl "
txtbox = CType(e.Item.Cells(2).Controls(0), TextBox)
txtvalue = txtbox.Text
MYCONN.Open()
mycomm = New SqlClient.SqlCommand(sqlcomm, MYCONN)
mycomm.Parameters.Add(New SqlClient.SqlParameter("@cl_name", SqlDbType.VarChar, 30))
mycomm.Parameters.Add(New SqlClient.SqlParameter("@cl", SqlDbType.VarChar, 3))
mycomm.Parameters("@cl_name").Value = txtbox.Text
mycomm.Parameters("@cl").Value = DataGrid1.DataKeys(CInt(e.Item.ItemIndex))
mycomm.ExecuteNonQuery()
Me.DataGrid1.EditItemIndex = -1
MYCONN.Close()
DataBind()
end sub