Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
290
Problem with sorting in ultrawingrid for currency column
posted

Hello

In my ultrawingrid, for one of the column I need to show currency symbol (like $20,000), so for this the datatype for the column is given as String, so since it is a string datatype it is sorting alphabatically, but I need to sort this according to the amount value given on header click action.

Parents
  • 469350
    Offline posted

    If you want to show a currency symbol in a column, you don't need to store the data as a string. Storing numeric values as strings will cause problems with sorting, filtering, and other areas.

    What you should do is store the data as Currency or Decimal and then use the Format property of the grid column to format the display as currency. 

Reply Children