Does the ultracombo provide a property / method call for wild card auto complete / search functionality? i.e. I want the user to type in *asp* and get the records (wasp, asp) and filter the remaining out. Im sure it will be easy enough to write, just curious to see if functionality already exists
What you have here will work, but it's probably not the most efficient way to do it. I would probably recommend using the ColumnFilters to apply a filter to the rows, rather than looping through the row and setting hidden on each one. Another option would be to use the InitializeRow event and evaluate each row rather than looping.
Also, it's more efficient to get the value of a cell using the GetCellValue method of the row, instead of referencing the Cell object, itself. That way the grid doesn't have to create a Cell object.
Like I imagined, this was not to hard to accomplish. Just wanted to post the simple code I used in case someone else finds a need for it. The code currently only works (well) with one wild card, more than one with this logic slows the operations down significantly; as you can see I am attempting all ascii characters so for each wild card you will have 256 results i.e. *asp* would return a result set of 512. I'm sure regular expressions would be the more logical approach, but this was quick and easy and pretty much what I needed.
{
// initialize a new array list for temporary storage of the wild card replacement results
}
else
// Hide all of the rows
// build a result set; loop all ascii characters and replace the wild card with each
// add the current result to the arraylist
arrPossibilities.Add(Expression.Replace(WildCard, rChar));
// for each result
// for each row
// if the "Cell" contains the result display the row