c# ListBox X2 DataTableX2 copy all between

[piercy]

Ill start by outlining whats in place currently.
tblData will display a list of people that can be used based on a set of filters that can be set on a filters above (name age etc.etc.). This tbl is a datasource for lbData... Then i have tblTo. this is a datasource for lbTo (original eh?). I want to be able to copy people between the two DataTables to show a receipiants listbox(lbTo) and then everyone else in the other.

If there are no filters applied and i want every one its a strait tblTo = tblData.Copy(); If there are filters applied then firstly i only want the ones wich are filtered (which is fine because the datatable only contains the filtered results the main list is stored elsewhere). The problem is. Say i want all people in tech so i filter tech and add all. Fine no problem. Now if i go find all the billing people and add them all. i dont want to overwrite the people already copied so i cant just do tblTo = tblData.Copy();... I tried using merge but my app seemed to crash. Ive already got it for copying single or mutliple (although im going to try speed it up).

Anyone got a way of transfering the data(all data in tblData -> tblTo). Doing it in reverse should be easy cos i just clear tblTo... also the filters dont get applied to tblTo.

Many Thanks,
Regards,
Piercy

Edit: tblTo.Merge(tblData); works however it takes about 5 minutes to complete... I dont think this way is viable unless im doign something wrong. The total people int he database at the moment is 2500 so im not expecting it to be lightning quick btu i think 5 minutes ish is too slow.

[piercy]

Ok, ive put some timing checks in and it seems the problem aint copying them its remmoving them from the old table. Doing Row.Delete(); then table.Accept and doing table.rows.remove(row); Both seem to be slow(ish) but when you working on 2500 value even 0.2 seconds per result is a bit much really.

Any Ideas?