DataGrid Problem
-
Can anyone help ... i'm developing an ADO.NET prog., here is a brief description : --dataSet X contains all tables. --dataSet Y : temp dataSet for filtering some table views (every search session Y is created and shipped with the chosen table(only one table) from X). --after the user build the search criteria (by entering some values for some columns or choosing predefined values for lookup columns)he clicks Accept. -- the Accept button deletes the dirty copy of the table (if exists),which may exists from a previous search session, then Copies another copy(clean one) of the table (original table copied at the start of search session) existing in (Y) and apply the filteration criteria by deleting those rows (from the second table) which does not match the search criteria. ****Important:When the user clicks Accept AGAIN the filtered table (in Y) is deleted and then copy a new one from the already existing one.*********** --after all filteration is done, a dataGrid (M) is bound to (Y) and the filtered table(second table). ********** PROBLEM ********** --when the user CHANGES the search criteria (by changing any value or adding new condition), he then presses Accept but (M)refuses to view the updated table. --note that the first time of search goes ok, but no further results are dispalyed correctly(the first search result lasts forever on M) if the search criteria changes even though the filtered table in (Y) has changed. **** Code **** AcceptButton() { layer1.ReloadTempTable(); for(int i=0;i