How this query is getting the data? Linq is used in this

Hello All,

I have one .Program

In this i am unable to get the following code how its working …
image

Can any one please help me with this???

@Seem,

Are you getting any error?

It looks you are looping a datatable, but the sheetNames may be a excel sheet name collection.
The datatable row for the column MODE should match some excel sheet name, then that sheet name will be assigned to the SheetName variable.

@sarathi125

No i dint get ur point…

i am having the folowing code. this code is simple… Only the linq query is bothring
image
it gets 4 sheets. - it goes to the List variable.

image
it has Abby DT

then it is looping through the code
image

I am looping through the list

Hi @Seem

are you able to print the sheet name based on linq because it is valid

Thanks
Ashwin S

1 Like

Hi @AshwinS2

yes it is working… its correct code…
I am not able to get how this code is working . So i posted it over here…

Can you please help me with this…
i have added only those sequenes related
i did single step too… could not gert it

and finally
i got it :slight_smile:

i see that going to 1st row in the Mode column where ever the AIR is there its taking…
thats what the contains means… Its so simple…
i actually changed string n tried it…
"Laptop AIR jkdjgoirejgokrepogkrepogktrpgmlkfpokgpor "

Its a simple string option…

ONE more thing is - from the List in SheetNames - at zero th postion its having AIR.
So if this is there, then it takes.

Suppose if u make it contains(1) – the 2nd value of the SheetNames - List

uff this Linq Query - i am new to this Linq…

:slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.