If I enter something in the text box and click filter.
The grid should show all the rows which contains (not exactly equals but contains) the word in atleast one or more of its columns which is entered in the text box.
The grid should show the row even the word is there in one column only.
for example : I have entered "I" in the text box.
so the grid should show the row "Singapore" even the country short code doesn't contain "I" for that row.
Kindly help me to achieve this.
Thanks in advance
Hi Can I have a update on this.
Do you have option to search through infragestic grids like find option in DevExpress WinGrid?
Thanks.
Unlike the sample attached here, your sample is showing the grid's FilterRow. So you would probably want to turn that off. Unless you want the user to be able to filter columns in addition to the textbox that filters on the whole grid. That doesn't really make a lot of sense, though, and it would be pretty confusing, I think.
So something in your code must be setting AllowRowFiltering and FilterUIType. Or maybe loading a layout which is setting those.
Hi I have use your logic but as you can see in my attachment it will shows the text what I have search is shows in every column.
Hope your reply soon.
Hello ,
After further investigation it turns out that the AoutOfMemorry exception occurs because of the foreach loop which access each cell of the grid, this force the grid to create UltraGridCellObject and corresponding cell enumerator and when there is significant amount of cells (on may machine this is 350 000 x 27) it cause the exception. So solution here is to replace foreach with for loops and works directly with corresponding column filters. However investigating this issue I got another idea which is much easier for implementation and doesn’t cause AoutOfMemorry exception. Please see modified sample.
I hope that this will helps you.
Hi,
Can I have update on this?
Thanks