예제 #1
0
        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));
        }
예제 #2
0
        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));
        }