Excel Autofilter in datagrid
-
Hello! Does anyone know the code to get an autofilter in a datagrid? This feature exists in Excel and it allows successives filters to data using combobox in column header. If is not possible to code this, is there anyway to call this feature directly from Excel I'm building a standalone app in c#. I appreciate your help Thanks Rui Fernandes
-
Hello! Does anyone know the code to get an autofilter in a datagrid? This feature exists in Excel and it allows successives filters to data using combobox in column header. If is not possible to code this, is there anyway to call this feature directly from Excel I'm building a standalone app in c#. I appreciate your help Thanks Rui Fernandes
You're going to have to code this from scratch or try and find a 3rd partyy DataGrid component that will allow you to do this. Excel will not export it's functionality to a datagrid, it only works with an Excel worksheet. Basically, you're going to have to provide the user interface, drop down boxes to allow selections of the filters, and provide code to handle the filtering of data (using DataView objects) and binding the datagrid to the new dataviews you create. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome