Hi,
I want to display text and value different in the grid cell.
If column data type is decimal or datetime then when server is returning with null then it should display null instead of empty, I have applied the solution to assign the null text in cell. But that property assign null whether it is empty string or null value from server.
I'm not sure I understand what you mean. What do you mean by empty? I am not aware of any empty value for a numeric field... unless you mean zero.
First of all thanks for reply.
My question is that, Whether can we apply different values to text property and value property of wingrid cell.
When ever we are running a query if null was entered in that row date then it should display null. That means no date was entered in this row.
If I m providing a criteria select data in particular that rang then if data does not exists in provided data range the it should display empty value instead of null.
I am reading data from file. File contains empty data and null value I want to display accordingly. Because if I am displaying data null in empty cell then customer will consider that now values was enter in this. While this empty values means no values is present in that range. For datatype datatime and decimal.
Further can we provide formatting like excel, Different formatting for different cell. Like for .rows[0].cell[0]= 5.25
.rows[1].cell[0]= null and .rows[1].cell[0]= is it possible to apply different data type to same column for different cell.
If you need code I can provide you.