Filtering data in a DataSet - Datagrid
Posted on 2006-07-03
This project involves retrieving records out of a database with a Select statement run through a Data Adapter.
I have a show list button on the form that will populate the datagrid. I'm planning on reading all records from the table into the DataSet and then use this button to filter what will actually appear in the DataGrid.
I've added to From Date and To Date so I plan on using a between statement to populate the DataGrid.
A friend helped me create a function called CreateTableStyle() to format the column headers and the Mapping Names to get right piece of data displayed in this column.
I'm not sure if I add this data filter to the SQL String query from the form or I apply this filter to the DataSet or just the DataGrid.
What's the preferred method?