 |
| |
สอบถาม การประกาศ GridView_RowUpdated ต้องประกาศยังไงหรือครับ ผมไม่ค่อยเข้าใจ |
| |
 |
|
|
 |
 |
|
พี่ทุกคนครับ ผมมีเรื่องรบกวนสอบถาม การประกาศ GridView2_RowUpdated ต้องประกาศยังไงหรือครับ ผมไม่ค่อยเข้าใจเท่าไร
แต่ผมอยากได้ค่าที่หลังจาก คำนวณ RowUpdate เสร็จแล้วมาคำนวณต่อCode (VB.NET)
Protected Sub GridView2_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView2.RowUpdated
Dim Remaining As Label = DirectCast(GridView2.Rows.FindControl("lbl_remain"), Label)
Dim CCN As Label = CType(GridView2.Rows.FindControl("lbl_ccn"), Label)
Dim ASSY As Label = CType(GridView2.Rows.FindControl("lbl_assy"), Label)
Dim Completed As TextBox = CType(GridView2.Rows.FindControl("lbl_qtycomp"), TextBox)
Dim QTY As Label = CType(GridView2.Rows.FindControl("lbl_qty"), Label)
Dim Completed As String = DirectCast(GridView2.SelectedRow.FindControl("lbl_qtycomp"), TextBox).Text
Tag : .NET, Ms SQL Server 2005, VBScript, Web (ASP.NET), VB.NET
|
|
|
 |
 |
 |
 |
| Date :
2011-03-16 15:19:59 |
By :
uyakop |
View :
1077 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (VB.NET)
Protected Sub myGridView_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles myGridView.RowUpdating
'*** CustomerID ***'
Dim txtCustomerID As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditCustomerID"), TextBox)
'*** Email ***'
Dim txtName As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditName"), TextBox)
'*** Name ***'
Dim txtEmail As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditEmail"), TextBox)
'*** CountryCode ***'
Dim txtCountryCode As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditCountryCode"), TextBox)
'*** Budget ***'
Dim txtBudget As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditBudget"), TextBox)
'*** Used ***'
Dim txtUsed As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditUsed"), TextBox)
strSQL = "UPDATE customer SET CustomerID = '" & txtCustomerID.Text & "' " & _
" ,Name = '" & txtName.Text & "' " & _
" ,Email = '" & txtEmail.Text & "' " & _
" ,CountryCode = '" & txtCountryCode.Text & "' " & _
" ,Budget = '" & txtBudget.Text & "' " & _
" ,Used = '" & txtUsed.Text & "' " & _
" WHERE CustomerID = '" & myGridView.DataKeys.Item(e.RowIndex).Value & "'"
objCmd = New OleDbCommand(strSQL, objConn)
objCmd.ExecuteNonQuery()
myGridView.EditIndex = -1
myGridView.ShowFooter = True
BindData()
End Sub
|
| |
|
|
| |
| Date :
2011-03-16 17:10:27 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ขอบคุณมากครับพี่ mr.win
แต่ถ้าจะใช้ภายใต้ myGridView_RowUpdated ต้องเขียนไงหรือครับ
|
| |
|
|
| |
| Date :
2011-03-16 17:48:00 |
By :
uyakop |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
