27-11-16, 12:26 AM
PHP كود :
Dim strsql As String = _
"UPDATE [USE_R] " & _
"SET [USER_NAME] = @USER_NAME, " & _
" [PASS] = @PASS, " & _
" [P1] = @P1 " & _
"WHERE [USER_ID] = @USER_ID "
Using acscmd As New SqlClient.SqlCommand(strsql, sqlconn)
acscmd.Parameters.AddWithValue("@USER_NAME", Textuser.Text)
acscmd.Parameters.AddWithValue("@PASS", textpassword.Text)
acscmd.Parameters.AddWithValue("@P1", CheckBox1.Checked)
acscmd.Parameters.AddWithValue("@USER_ID", TXT_ID.Text)
If sqlconn.State <> ConnectionState.Open Then sqlconn.Open()
Dim ret As Integer = acscmd.ExecuteNonQuery()
sqlconn.Close()
If ret > 0 Then MsgBox("تمت عملية التعديل على البيانات")
End Using
