 |
|
ทำไมมันไม่อัพเดทข้อมูลใน 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 :
1017 |
Reply :
6 |
|
 |
 |
 |
 |
|
|
|
 |