Hi, I would like to get all values in column C and store it in a variable without using loop function because I have more than 10k data and it would be time consuming for me to loop through every row.
I tried using multiple ways (example as below) that I found in this forum but all of it doesn’t work.
- (From row In DT.AsEnumerable() Select Convert.Tostring(row(2))).ToList()
- (From r In dt.AsEnumerable Select r(2).ToString.Trim).ToArray
- dt1.AsEnumerable.Select(Function® r(2).ToString.Trim).ToArray
- (From x in dt.AsEnumerable
This is the value that I get when I run it.