How to mark lowest value in grid

[llmclaughlin]

Trying to show image only for the lowest offer_amount row. How would you determine that value?

Private Sub dgdCurrent_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles dgdCurrent.RowDataBound

If e.Row.RowType = DataControlRowType.DataRow Then

If mdecLowOffer < Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "OFFER_AMOUNT")) Then
mdecLowOffer = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "OFFER_AMOUNT"))
e.Row.FindControl("lbEDITER").Visible = True
Else
e.Row.FindControl("lbEDITER").Visible = False
End If

End If

End Sub


Thanks

Louie

 

[PRPhx]

You need to do a couple of things.
1) Use a data table
2) Use a dataview

Here is a simple example I found using google:

http://www.vbdotnetforums.com/cf-data-access/7973-sort-datagrid.html