Find last row by refer column name

Help Activities
, ,
10

@Stef_99

Can you check this

lastColumnIdrownumber = dt_input.AsEnumerable().ToList().FindIndex(Function(x) String.IsNullOrWhiteSpace(x("ID").ToString())).ToString

lastrowNamenumber = dt_input.AsEnumerable().ToList().FindIndex(Function(x) String.IsNullOrWhiteSpace(x("Name").ToString())).ToString

Hope this helps!

1 Like