Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string cmdString = "UPDATE users SET username=@username,password=@password,email=@email WHERE ID=@ID";
- cmd.Parameters.Add("@username", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[1].Value;
- cmd.Parameters.Add("@password", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[2].Value;
- cmd.Parameters.Add("@email", OleDbType.VarChar, 100).Value = dataGridView1.Rows[RowIndex].Cells[3].Value;
- cmd.Parameters.Add("@ID", OleDbType.Integer, 100).Value = dataGridView1.Rows[RowIndex].Cells[0].Value;
- cmd.CommandText = cmdString;
- cmd.Connection = con;
- cmd.CommandType = CommandType.Text;
- cmd.ExecuteNonQuery();
Add Comment
Please, Sign In to add comment