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.
Hi Mike,
Thanks for Reply
These columns are editable by user. I am not aware of how to use CreationFilter or DrawFilter.
If you can explain with a small example then it would be much help full for me.
If the user can edit the cells, then a DrawFilter or CreationFilter won't work. Your only option would be to either use an unbound column (and hide the real column) or use a DataFilter.
The DataFilter is probably the best approach. For samples of using DataFilters, check out the Infragistics Knowledge Base. Do a search for the word "DataFilter".
Thanks for suggestion but I am not able to find DataFilter in knowledge Base. I tried to search.
One thing the information which I have provided you early in the form of table is it possible to read like that in the grid.
Plaese explain me with short example. So that I have an idea how to go about it.
Syed Sadaqat Hussain said:Thanks for suggestion but I am not able to find DataFilter in knowledge Base. I tried to search.
I just did a search in the Infragistics Knowledge Base for the word DataFilter and found three articles:
http://devcenter.infragistics.com/Support/KnowledgeBaseResults.aspx?type=Full&query=DataFilter&articletypes=0&age=0&sort=LastModifiedDate&samplesonly=0
Syed Sadaqat Hussain said:One thing the information which I have provided you early in the form of table is it possible to read like that in the grid.Plaese explain me with short example. So that I have an idea how to go about it.
I do not understand what you are asking.
Thanks for reply and sorry for late responce.
What ever you suggest that is not working in my case:
This is my sample data you tell me solution.
Column1(decilma) Column2(string) Column3(Date)
1.222 Hello 12/3/2008
null Hello null
3.25 IBM
IMB 13/3/2008
5.65 null
What are you doing and why isn't it working?