Hello everybody,
I’m having a problem with one of my assigns.
I have two datatables, who I compare, i only keep the datarows from one datatable that are not available in the other.
Sometimes it has no datarows but then i got this error: Assign: The source contains no DataRows.
I read some things about .select>0 but this doesn’t work in my assign. Does anyone has a solution for this assign?
assign:
dtOutput : (From t1 In dtPB0106.AsEnumerable() Group Join t2 In dtQuerie.AsEnumerable() On t1.Field(Of String)(“Column1”) Equals t2.Field(Of String)(“Column0”) Into tg = Group From tcheck In tg.DefaultIfEmpty() Where tcheck Is Nothing Select t1).CopyToDataTable()
This works perfectly when we have datarows