Todd Burrell

Todd Burrell

  • NA
  • 15
  • 0

Filtering DataTable Against Second DataTable

Sep 14 2010 7:45 AM
In a method I am trying to develop, I have two DataTables named slotCounts and createdSlots.  The table createdSlots has a column TIMESLOT which is typeof(DateTime), and slotCounts has a column SCHDTIME which is typeof(DateTime), from which these tables can be related.

I want create a new DataTable consisting of rows from createdSlots except where there is a matching row in slotCounts.  Conversely, I could just delete those rows from createdSlots that have a matching row in slotCounts.

I have been able to filter DataTables in some other methods, but not filtering one DataTable against another.  Is this possible?

Answers (3)