|  |  | 
          
            | ทำไมมันไม่อัพเดทข้อมูลใน database ไม่ทราาบว่า Code ผมผิดตรงไหนหรือป่าวคับ 
 Code (ASP)
 
    Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click
        Dim ErrMessage As String
      
        ErrMessage = conn.ExecuteNonQuerywithErrorMsg("UPDATE InsuranceDetail Set Brok_name ='" & Me.ddlBrokerUpdate.SelectedValue.ToString() & "',CapitalIns='" & Me.tbxCapitalUpdate.Text & "',FloodProtect='" & Me.ddlFloodUpdate.SelectedValue.ToString() & "',ActStatus ='" & Me.ddlActUpdate.SelectedValue.ToString() & "',PersonalProp='" & tbxPersonalUpdate.Text & "',Damage='" & Me.tbxDamageUpdate.Text & "',Payment='" & Me.tbxPaymentUpdate.Text & "',CarBrand='" & ddlBrandUpdate.SelectedValue.ToString() & "',CarModel='" & Me.ddlModelUpdate.SelectedValue.ToString() & "',CarYear='" & Me.ddlModelUpdate.SelectedValue.ToString() & "',InsClass='" & ddlClassUpdate.SelectedValue.ToString() & "',EngineSize='" & Me.ddlInsertEngine.SelectedValue.ToString() & "'WHERE InsID='" & Me.DDlInsID.SelectedValue.ToString() & "'And InsYear='" & Me.ddlYearUpdate.SelectedValue.ToString() & "'")
        If ErrMessage = "" Then
            Me.lblStatus.Text = "แก้ไขข้อมูลเริยบร้อย."
        Else
            Me.lblStatus.Text = "แก้ไขข้อมูลผิดผลาด : " & ErrMessage
            PnlUpdate.Visible = False
            LoadData()
        End If
    End Sub
 
 
 Tag : ASP.NET Ms SQL Server 2008, VBScript, VS 2010 (.NET 4.x)
 
 
 |  
            |  |  
            | 
              
                |  |  |  |  
                |  | 
                    
                      | Date :
                          2013-06-24 16:10:51 | By :
                          banhanj | View :
                          1061 | Reply :
                          6 |  |  |  
                |  |  |  |  |  
            |  |  
		            |  |