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.
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.
I had given the format as e.Layout.Bands(0).Columns("Loan Amount").Format = "$#,##0.00"
but the problem here is if the value is negative it is showing like -$20,000 but it supposed to show like ($20,000)
Then your format needs to specify a different format for the 0 value.
In my grid the values 0 and NA are different.
One of the records can have NA value which is supposed to be string, so how can I sort the column numerically?
I only need is sort the column alphanumerically (numerics first, strings next).
Thanks
You would probably have to implement a SortComparer for the column.
Hi
I don't know what does Sortcomparer do. Can you please expalin me that and a sample code for me.
thanks in advance
There are lots of posts about this technique on the forums already. So a search for SortComparer or IComparer. Or check out the help topic for the SortComparer property on the column.
Thanks very much.
The help installs with the product and it's also available on the Infragistics web site: Infragistics Online Help Documentation
No I was asking you that is there any Infragistics help topics that explains each property in the software installed(Infragistics).
Sandy said:Also how do I get help topics regarding something in my IDE?
I'm not sure what you mean. If you want help on Visual Studio, then you should contact Microsoft.
Thanks very much, I had resolved my issue using IComparer.
Also how do I get help topics regarding something in my IDE?