08-17-2012, 05:33 AM
I want the user to be able to open the menu strips on the top select the field they wish to filter by and also be able to filter more than 1 field at a time.
Like say I wanted to filter Order Received and Town at the same time. What the query would do would filter the entries in the Datagrid. Then the remaining entries would be displaying in the Datagrid. Then when the user selects the entry they want, all of it's data goes into the textboxes, and be ready for editing.
I've spent a good deal of time researching the query builder and it seems that it would be better to do a LINQ.
Like say I wanted to filter Order Received and Town at the same time. What the query would do would filter the entries in the Datagrid. Then the remaining entries would be displaying in the Datagrid. Then when the user selects the entry they want, all of it's data goes into the textboxes, and be ready for editing.
I've spent a good deal of time researching the query builder and it seems that it would be better to do a LINQ.