public static Status update_user_bio(String userid, String bio) { String query = "update users_tbl set user_bio=@bio where user_id=@userid"; SqlCommand command = new SqlCommand(); //parameters command.Parameters.AddWithValue("@bio", bio); command.Parameters.AddWithValue("@userid", userid); return(ConnectionInit.go_to_insertingToDB(query, command)); }
public static Status update_fist_last_name(String userid, String firstname, String lastname) { String query = "update users_tbl set user_first_name=@first_name,user_last_name=@last_name where user_id=@userid"; SqlCommand command = new SqlCommand(); //parameters command.Parameters.AddWithValue("@first_name", firstname); command.Parameters.AddWithValue("@last_name", lastname); command.Parameters.AddWithValue("@userid", userid); return(ConnectionInit.go_to_insertingToDB(query, command)); }