datatable

col1,col2

111,Y

666,Y

333,Y

333,N

666,N

444,N

555,N

result…

col1,col2

111,Y

666,Y

333,Y

444,N

555,N

datatable

col1,col2

111,Y

666,Y

333,Y

333,N

666,N

444,N

555,N

result…

col1,col2

111,Y

666,Y

333,Y

444,N

555,N

Sorry I did not understand your requirement. Could you please tell more details for better understanding.

dtDatatable=dtYourDatatable.DefaultView.ToTable(True,“ColumnName1”,“ColumnName2”)

Try the above linq query for getting the distinct value.

Thanks,

Mohanraj.S

1 Like

thank you

i will try it.

Did that work dude.

if it is working then Please mark this as solution.

Thanks,

Mohanraj.S