locked
consultations per year RRS feed

  • Question

  • User2063550425 posted

    I would like no entity to check the 3 customers who spent the most

    thanks

    Sunday, December 16, 2018 8:03 PM

All replies

  • User-271186128 posted

    Hi jeancarlosc,

    Welcome to asp.net forum.

    I would like no entity to check the 3 customers who spent the most

    Please explain more details about your questions? what do you mean about "no entity"?

    If you want to get the customer who spent the most time, you could sort the customer by the spent time, then get the first (descending sort) or last (ascending sort) one.

    If you are using SQL server database to store the customers' information, you could use the SQL ORDER BY Keyword to sort the data, then, get the item.

    If you are using DataTable to store the data, you could use LINQ to DataSet query and orderby clause to sort the data.

    Best regards,
    Dillion

    Monday, December 17, 2018 2:59 AM