ASP.NET

[DataObjectMethod(DataObjectMethodType.Update)]
        public static int updateUser(UserData userData)
        {
            MySqlCommand cmd = new MySqlCommand();

            try
            {
                DB_Connection conn = new DB_Connection();
                cmd.Connection = (MySqlConnection)conn.DBConnect();

                cmd.CommandText = "updateUser";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(new MySqlParameter("USERID", userData.UserID));
                cmd.Parameters.Add(new MySqlParameter("USER_LAST_NAME", userData.UserLastName));
                cmd.Parameters.Add(new MySqlParameter("USER_FIRST_NAME", userData.UserFirstName));

                int i=cmd.ExecuteNonQuery();
                return i;
            }
            // catch (Exception ex)
            //   {
            //  Console.WriteLine (ex.Message);
            //  }
            finally
            {
                cmd.Connection.Close();
            }
        }

REATE DEFINER=`USERDB`@`%` PROCEDURE `updateUser`(IN USERID VARCHAR(7),IN USER_LAST_NAME VARCHAR(40), IN USER_FIRST_NAME VARCHAR(20)
BEGIN
       UPDATE USERS SET USER_LAST_NAME = USER_LAST_NAME, USER_FIRST_NAME = USER_FIRST_NAME where USER_ID = USERID;
END