Hi I have a numberic column in my grid set to the NumberType of Decimal1.
<GUI:BindColumn Caption="Variation No" CommandText="" CustomFormat="" DataField="VariationNo" AlternativeStyle-BackColor="#FFFFDD" Style-BackColor="#FFFFDD" ImageUrl="" Width="75px" NumberType="Decimal1" IsReadOnly="True"> </GUI:BindColumn>
When I click on the header for this column it orders the data, but it does so based on the data being a string instead of a number.
ie 1,11,12,13,2,3,4,5,6,7,8,9 instead of 1,2,3,4,5,6,7,8,9,10,11,12,13
How can I get this to be ordered properly as a numeric field.
Any advise or assistance would be greatly appreciated.