Results 1 to 9 of 9

Thread: The largest and the smallest numbers in a DataGridView

Hybrid View

  1. #1
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,508

    Re: The largest and the smallest numbers in a DataGridView

    If this data is coming from a database like Sql Server or MS Access then you can handle this issue with your SQL statement

    Here is an Access example,

    Smallest
    Code:
    Select Top 10 column32, theNameColumn From lots where theNameColumn='someName' ORDER BY column32 ASC
    Largest
    Code:
    Select Top 10 column32, theNameColumn From lots where theNameColumn='someName' ORDER BY column32 DESC
    I think SQL Server uses TOP(10)
    Last edited by wes4dbt; Jul 1st, 2017 at 04:24 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width