Good solution to filters on datagridview
I'm developing an info managment system. I am using Access as my db.
Ufortunetly, the datagridview doesn't support filtering rows by column content.
I'm using TableAdapter as the source and I was trying to use LINQ to SQL but it seems that the access provider is not supported. \:
I have also heard of hibernate.
Does LTS doesn't support ACCESS?
What should I use instead?
What is the best way to use filters (filters in excel for example are perfect, cuz it authomatically builds the list of filter options for each column).
Thank you very much.