Guest User

Untitled

a guest
May 26th, 2018
1,840
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. string cmdString = "UPDATE users SET username=@username,password=@password,email=@email WHERE ID=@ID";
  2. cmd.Parameters.Add("@username", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[1].Value;
  3. cmd.Parameters.Add("@password", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[2].Value;
  4. cmd.Parameters.Add("@email", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[3].Value;
  5. cmd.Parameters.Add("@ID", OleDbType.Integer, 100).Value = dataGridView1.Rows[RowIndex].Cells[0].Value;
  6. cmd.CommandText = cmdString;
  7. cmd.Connection = con;
  8. cmd.CommandType = CommandType.Text;
  9. cmd.ExecuteNonQuery();
Add Comment
Please, Sign In to add comment