|
Hi, Here is what I want to achieve. I have a datatable returned from a query. I have 3 grids on window. The 3 grids have to show the data from the same source data table but with a different Select criteria for each of them. (I run the query only once and then I perform "Select" on DataTable for each of the grid). Now the user can add rows into any of these grids (by invoking a popup window through a context menu, enter new data and click OK). What is the best way so that 1. I can keep only one DataTable as my main source of data. 2. Grids show the data from same source but with different select clause. 3. Users can add new records to the grids (as a result the main datatable should also have a new row). I am open to any solution even without DataTable. Just want to keep the main source collection synchronized from the smaller collections. Please suggest what should I do. Thanks. AM
|