Member Avatar for empyrean

hello everyone.. i have a question.. i am using datagrid and binding the columns using datatable..i have grid with columns Area, name, date, country, comments. Now i have to filter the data using two list boxes with contains area and name distinct values. if user selects one location or more and on click of submit the data should filter accordingly.. please suggest how to do this..

  • 2 Contributors
  • 2 Replies
  • 142 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by nick.crane
Member Avatar for empyrean

Any suggestions please...

Member Avatar for nick.crane

If you have a BindingSource you can use the Filter property of this.
It take a string similar to the WHERE part of an SQL query. E.G. "Area='Selected Area 1' OR Area='Selected Area 2'".

In your Submit button get the selected Area and Name values from your listboxes using the SelectedItems collection.

Either append to a string filter; variable or use a StringBuilder to create the filter string you need and set the BindingSource.Filter property.

You will find a simple example here: MSDN BindingSource.Filter Property

Edited by nick.crane because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.