if i display sql queries result on my wingrid and some or most part of the grid has a zero as a cell value ?can i format the cell to display blank instead the zero or should i need to visit each cell and blank it?
Thanks.
If it is a Interger column then you can set MinValue as 1
ultragrid.DisplayLayout.Bands[0].Columns["ColumnOne"].MinValue =1;
Manoj Kumar said: If it is a Interger column then you can set MinValue as 1 ultragrid.DisplayLayout.Bands[0].Columns["ColumnOne"].MinValue =1;
I don't think that's a good idea. If the user goes into the cell and tries to edit it and then leaves with an empty cell, intended to put a 0 back into the cell, it will raise an exception, since the MinValue is 1.
There's no easy to way to make the cell blank when it's a 0. You would have to use a filter of some kind. Probably the easiest thing to do would be to use a DataFilter to translate a 0 to an empty string and vice versa.