how can i get Excluded datatable ?

Help
#1

I want to create a datatable by extracting the “MAN” data (ManDT) from the original datatable
and making the rest of the datatable to WomanDT.
I made ManDT, but I don’t know how to query WomanDT
can you help me?

*********Invoke Code ************************************
Dim ManDT As EnumerableRowCollection(Of DataRow) = From DT In PeopleDT.AsEnumerable() Where DT.Field(Of String)(“Column1”) Like “MAN”

ManDTcount = ManDT.Count()

Dim WomanDT // i want to Except ManDT
how can i get WomanDT ?

#2

@alisha

It will give you Woman DT.

Dim ManDT As EnumerableRowCollection(Of DataRow) = From DT In PeopleDT.AsEnumerable() Where DT.Field(Of String)(“Column1”) Not Like “ MAN ”