GST Billing Software

header image

Filter Grid Depending on a Particular Column

Erachana Line

33. How to filter grid depending on a particular column (Ex. Search Text box in a Customer Form, above the Grid)?

To achieve the grid filter, First, create Expression and use ControlAdapter.Filter as shown in the below Example. Then, Associate the Expression to TextChange event if it's from Textbox.

Ex:

if (TextBox_Id.Text.Length > 0) { ControlAdapter.Filter(Grid_Id, string.Format("Column _Name LIKE ('%{0}%')", TextBox_Id.Text.)); } else { ControlAdapter.Filter(Grid_Id, ""); }