Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
385
Wingrid ValueBasedAppearnce Formula based on Value supplied programmatically at runtime
posted
Hi,I have built a windows form to search multiple database tables(i.e. an invoice history table, an open orders table, etc.) for 'hits' based on the search criteria entered by the user at runtime. When the user searches, a wildcard search is conducted by the server and returns records from the previously mentioned database table that contain the search string in any of the table’s cells(This is so that you can enter one piece of information, and search multiple fields, as well as tables, at the same time). 4 ultrawingrids are populated with the results from the respective tables that are searched. I am using the like operator on the server so that if the search criteria is "oc", it will return records with cells containing entries like "mock", "mocha", etc.I would like to highlight the cell in any given record(row) that contains the data that caused that record to be returned(i.e. to match the search criteria.  I have tried using the value based appearance, and utilize a formula, but even with the ultracalc manager on the form, I cannot seem to reference the value contained in the textbox that has the search criteria.Any thoughts would be greatly appreciated.

Rick

  • 37774
    posted

    In order to get the text box to appear in the calc network, you need to take a look at the extender properties that the UltraCalcManager adds to the various controls and fill in the fields that will provide enough information for the manager to pull the value.  For example, on my UltraTextEditor, I assigned an Alias of "Search", the PropertyName of "Text", and the TreatAsType to "System.String", so my control will appear in the Formula Builder is "Search.Text" and is references in formulas by "[//Search]".

    -Matt