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 ?