How to datatable Select

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

@sumouse

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

@sumouse,

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.

@sumouse,

Did that work dude.

if it is working then Please mark this as solution.

Thanks,
Mohanraj.S