Remove data rows on based on a column value


#1

Hi Guys,

I have a master Dt with 100 columns and in another data table i have 80 columns of same data which is in master Dt . so i want another 20 columns of data based on a column value

i have used the following expression but i dont want the distict column because in my case is not suggestable can any one help me with the command that in case of data row , i want to give the column value

dt_data.asEnumerable().except(dt_exclusion.asEnumerable(),datarowcomparer.default).copytodatatable
any suggestion will be appreciated

thanks in advance


#2

@skrishna

Above command is working fine. I getting rest 20 datarow values and which can be merged to the datatable with which is of 80 rows.


#3

yes,
in my case both the datatables are not identical . one extra column is there in the one datatable . so its not working

so, i am looking for on base of any column , can we except the datatable