Find last row by refer column name

[Stef_99 (Mary)]

Hello,

I have datatable.
I want find last row column ID and column Name
by not user loop

Please guide me for solve it.

Thank you

[ashokkarale]

@Stef_99

I want find last low column ID and column Name

@Stef_99,

Can you elaborate this more?

[V_Roboto_V]

Hi @Stef_99

I am a bit confused, you want the last row based on Column Name??

[sppal.c]

@Stef_99 you mean you wants to get the cell value of last row by referring the column name? if so you can use the below linq

dt.AsEnumerable().Last()("ColumnName").ToString

[Sanjay_Bhat]

Hi @Stef_99

You can get the last column values this way

columnId = dt_input.Rows(dt_input.RowCount-1)(“ColumnId”)

columnName = dt_input.Rows(dt_input.RowCount-1)(“ColumnName”)

Hope this helps!

[Anil_G (Anil Gorthi)]

@Stef_99

if you need last column name then try this

dt.Columns(dt.ColumnCount-1).ColumnName will give the last column name

if you mean the index when you say ID then dt.ColumnCount-1 will give it

cheers

[Stef_99 (Mary)]

Example data

I want last number row column ID =5
last number row column Name = 3

Thank you

[sppal.c]

@sppal.c

dt.AsEnumerable().Last()(“ColumnName”).ToString

you can use this linq
dt.AsEnumerable().Last()(dt.ColumnCount-1).ToString

[Stef_99 (Mary)]

@sppal.c I don’t want value in last row.

Expect data

last number row column ID =5
last number row column Name = 3

[Sanjay_Bhat]

@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!

[ashokkarale]

@Stef_99,

This should give you Last Non-Empty Row Number for Column “ID”

dt.AsEnumerable().Select(Function(row, index) New With {Key .Index = index, Key .Row = row}).Reverse().First(Function(x) Not String.IsNullOrWhiteSpace(x.Row("ID").ToString)).Index + 2

This will give you Last Non-Empty Row Number for Column “Name”

dt.AsEnumerable().Select(Function(row, index) New With {index, row}).Reverse().FirstOrDefault(Function(x) Not String.IsNullOrWhiteSpace(x.row("Name").ToString)).index + 2

Input:

Output:

[Stef_99 (Mary)]

output now show -1

Not true

[sppal.c]

@Stef_99 you can directly use the count method.

dt.RowCount-1 will be equals to the ID of last row

dt.ColumnCount-1 will the the ID of last column in your datatable