|
|
|
โค้ด อัพเดต error คับ พอดีว่ามือใหม่ ไม่ค่อยจะเก่ง ช่วยหน่อยน่ะครับ สอบโปรเจค อีกไม่กี่วันแล้ว |
|
|
|
|
|
|
|
มันไม่มีค่าครับ อันที่จริงควรใส่ 'xxx' ด้วยครับ
Code (VB.NET)
Query = Query + " Sex = '" + txtSexCus + "' "
|
|
|
|
|
Date :
2012-03-24 17:29:16 |
By :
webmaster |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
xxx ใส่ตรงไหนครับ
|
|
|
|
|
Date :
2012-03-24 17:45:43 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code (VB.NET)
Query = "UPDATE Customer SET CustomerName ='" + txtNameCus.Text + "'"
Query = Query + "Sex = " + txtSexCus.Text
Query = Query + "Address = " + txtAddressCus.Text
Query = Query + "Telephone = " + txtTelCus.Text
Query = Query + " WHERE CustomerID = " + txtIdCus.Text
Dim cmd As MySqlCommand = New MySqlCommand(Query, con)
MsgBox(Query)
Dim i As Integer = cmd.ExecuteNonQuery()
'If (i > 0) Then
'lblMsg.Text = "Record is Successfully Updated"
' lblMsg.Text = "Record is not Updated"
'End If
con.Close()
ช่วยเปลี่ยนแปลงให้หน่อยน่ะครับ
|
|
|
|
|
Date :
2012-03-24 17:49:21 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code (VB.NET)
Query = "UPDATE Customer SET CustomerName ='" + txtNameCus.Text + "'"
Query = Query + "Sex = '" + txtSexCus.Text + "'"
Query = Query + "Address = "' + txtAddressCus.Text + "'"
Query = Query + "Telephone = '" + txtTelCus.Text + "'"
Query = Query + " WHERE CustomerID = '" + txtIdCus.Text + "'"
Dim cmd As MySqlCommand = New MySqlCommand(Query, con)
MsgBox(Query)
Dim i As Integer = cmd.ExecuteNonQuery()
'If (i > 0) Then
'lblMsg.Text = "Record is Successfully Updated"
' lblMsg.Text = "Record is not Updated"
'End If
con.Close()
มันน่าจะไม่มีค่าครับ
|
|
|
|
|
Date :
2012-03-24 17:54:02 |
By :
webmaster |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Date :
2012-03-24 18:14:38 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ลืมใส่ comma ครับ มันไม่มีค่าด้วยครับ ดูจากตัวแปร
Code (VB.NET)
Query = "UPDATE Customer SET CustomerName ='" + txtNameCus.Text + "'"
Query = Query + ",Sex = '" + txtSexCus.Text + "'"
Query = Query + ",Address = "' + txtAddressCus.Text + "'"
Query = Query + ",Telephone = '" + txtTelCus.Text + "'"
Query = Query + " WHERE CustomerID = '" + txtIdCus.Text + "'"
Dim cmd As MySqlCommand = New MySqlCommand(Query, con)
MsgBox(Query)
Dim i As Integer = cmd.ExecuteNonQuery()
'If (i > 0) Then
'lblMsg.Text = "Record is Successfully Updated"
' lblMsg.Text = "Record is not Updated"
'End If
con.Close()
|
|
|
|
|
Date :
2012-03-24 18:54:12 |
By :
webmaster |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ยังฟ้องว่า error ที่เดิมครับ ฟ้องที่เดิมเลย
|
|
|
|
|
Date :
2012-03-24 19:32:45 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Date :
2012-03-24 19:41:29 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ได้แล้วครับ ขอบคุนมากๆๆ น่ะคับ
|
|
|
|
|
Date :
2012-03-24 19:53:03 |
By :
tomza |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 01
|