Advertisement
Guest User

Untitled

a guest
May 11th, 2016
330
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. SqlCommand cmd = new SqlCommand("update Users set Username=@Username,Password=@Password,Name=@Name,Address=@Address,Phone=@Phone,@Email=Email,@RoleId=RoleId", conn);
  2. cmd.Parameters.AddWithValue("@Username", username.Text);
  3. cmd.Parameters.AddWithValue("@Password", password.Text);
  4. cmd.Parameters.AddWithValue("@Name", name.Text);
  5. cmd.Parameters.AddWithValue("@Address", address.Text);
  6. cmd.Parameters.AddWithValue("@Phone", phone.Text);
  7. cmd.Parameters.AddWithValue("@Email", email.Text);
  8. cmd.Parameters.AddWithValue("@RoleId", DropDownList4.SelectedItem);
  9. conn.Open();
  10. cmd.ExecuteNonQuery();
  11. conn.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement