Query = Query + " Sex = '" + txtSexCus + "' "
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()
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()
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()
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง