Concat values from a datatable column excluding some

Is there any way to concat values from a datatable column excluding some values and blanks, without using for each loop?


Problem | Remarks
Test | Nothing much
Test1v |
Test2 | Need to Add more
Test3 | Nothing Much
Test4 | Too much Info

Need to Add more; Too much Info

IF You know the row index or specified rows which you need to concat the you should try this once
here rows(2) means 3rd row and item(1) means column of Remarks
thanks if any let me know…


You can try like this

String.Join(";",Dt.AsEnumerable.Where(function(x) Not {"","Nothing much"}.Contains(x("Remarks").ToString.Trim)))