Find first row and last row

[mark_rajkumar1 (mar)]

Hi there,

I want to create a datatable but however i wan to find the last row so i can read it and store it as datatable. With that i need values from a specific column the first and last row. How to achieve it?

[lrtetala (Lakshman Reddy)]

Hi @mark_rajkumar1

Use Find First/Last Data Row activity

Activities - Find First/Last Data Row

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@mark_rajkumar1

[lrtetala (Lakshman Reddy)]

@mark_rajkumar1

@mark_rajkumar1

i need values from a specific column the first and last row. How to achieve it?

firstValue = DT.AsEnumerable().First()(DT.Columns("ColumnName")).ToString()

lastValue = DT.AsEnumerable().Last()(DT.Columns("ColumnName")).ToString()

Regards,