vb.net - 从 Datagridview 列获取最小值

Question

我想从我的 datagridview 列中获取最低值!

我的datagridview的名称是datagridview1

这是我的数据 GridView :

|-Number-|

|---90---|

|---70---|

|---20---|

|---80---|

|---50---|

|---60---|

我一直在尝试一些代码:

Dim MinVal As Double = 99999999

For Each row As DataGridViewRow In DataGridView1.Rows

If row.Cells(0).Value < MinVal Then MinVal = row.Cells(0).Value

Next

TextBox9.Text = MinVal

没有错误。但结果是60而不是20

发生了什么？请帮助我!

Answer 1

    Dim Max As Integer = 0

    For Each rws As DataGridViewRow In DataGridView1.Rows
        If Max < rws.Cells(0).Value Then Max = rws.Cells(0).Value
    Next

'Maximum Value
Msgbox(Max)

对于最小值，您必须使用该最大值

    Dim Min As Integer = Max

    For Each rws As DataGridViewRow In DataGridView1.Rows
        If Min > rws.Cells(0).Value Then Min = rws.Cells(0).Value
    Next

'Minimum Value
Msgbox(Min)