How to fetch first value in specific column

[Sharanabasava (Sharanabasava Kallurmath)]

Hi Team,
I need to fetch first value from column using LINQ.
ie"Year" is equal to 2021

I have tried like this
dt1.AsEnumerable.Take(1).Select(Function(r) r(“Year”).ToString.Trim )

[Srini84 (Srinivas Kadamati)]

@Sharanabasava

To fetch the first value of a particular column then check as below
dt.Rows(0).Item(“Year”).ToString

Hope this may helps you

Thanks

[Sharanabasava (Sharanabasava Kallurmath)]

I don’t want to use loop

[Hiba_B (Hiba Beldi)]

@Sharanabasava The option that has given @Srini84 does not need a loop, you just have to assign it to a string

[Srini84 (Srinivas Kadamati)]

@Sharanabasava

I didn’t use any loop you will get direct value from the DT as @Hiba_B said

Thanks

[Pravin_Patil1 (Pravin Patil)]

If you want linq then you can make below changes in your code

varDT.AsEnumerable.Take(1).Select(function(r) r(“Year”))(0)