Hello,
This is in connection with my earlier post on Adding a New Unbound Row to WinGrid. Please refer to my Post as well as reply for the background scenario.
Now, based on the description, the new order in my ultragrid is actually in 2 states.
1. Pending: Order placed, waiting for admin approval
2. Approved: Order approved.
Now, I need to color the orders pending approvals. Once the orders are approved, the row color is reset to the default ones. Currently I have reset the color of the rows as WHITE background with BLACK as text color. I can color the rows at perticular index in the grid. But when the grid is sorted or grouped, the color is not(as it is colored based on indexes).
Can anyone suggest how should it be done?
Thanks a lot!
It's not a good idea to rely on the Index of a row, since the index can change. You should probably base the appearance of the row on a value of a cell within that row. You might also want to use the ListObject or ListIndex property of the row which return the underlying data object that the row is bound to or the index of that object in it's collection, respectively.
I could format the row with the PENDING status. I used the initialize row event of the datagrid which gave me the newly added row and I could format it accordingly.
Now, there is another problem. I need to reset the formatting of the row to the default one when I get the confirmation about the added order. Is there any way I can do that? Moreover, I happened to read about Conditional Formatting. Is there any way we can implement at run time as my datasource is populated and bound at run time.
Many Thanks!
Hi,
sagarbora said:Now, there is another problem. I need to reset the formatting of the row to the default one when I get the confirmation about the added order. Is there any way I can do that?
InitializeRow should fire for the row again when you change the value of any cell. So you just need to use an 'if' statement or a 'switch' inside InitializeRow to apply an appearance to the row or the cell based on the cell's current Value.
To revert the row back to the default appearance, you just reset the appearance you applied. So if you did something to the row.Appearance, you would call row.ResetAppearance. If it was a cell, you would do cell. ResetAppearance.
sagarbora said:Moreover, I happened to read about Conditional Formatting. Is there any way we can implement at run time as my datasource is populated and bound at run time.
Conditional Formatting is mainly for design-time. It's actually more difficult and needs more code to set this up at run-time, than it does to use the InitializeRow event.
I don't see a row.ResetAppearance. However I do see Row.Appearance.Reset. This article helped me find the Row.Appearance.Reset. I think this is a typo, but if not Mike please let me know. I could not find ResetAppearance.
Hm, I thought there was a ResetAppearance on the row. If not, then I'd recommend setting row.Appearance = null, rather than calling row.Appearance.Reset.
The former will clear the row.Appearance and the row will draw as normal.
The latter will reset all of the properties on the row's Appearance object. This is not good, because that appearance might be used by other objects and you don't necessarily want the other objects to have their appearances cleared.
You might also want to take a look at the WinGrid Performance Guide for some tips on how to do this most efficiently.