How to:
1.
SQL Update[
^]
2.
SQL Delete[
^]
However, modify them to use parameterized query so as to prevent
sql injection[
^]. For example:
Update Parameter:
string sql = "UPDATE users set email = @email where userid= @userid"
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@userid",txtUserID);
cmd.Parameters.AddWithValue("@email",txtEmail);
cmd.ExecuteNonQuery();
Delete Parameter:
string sql = "DELETE FROM users where userid= @userid"
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@userid",txtUserID);
cmd.ExecuteNonQuery();