Selection

Good Morning Everyone!!!
I come to ask question for you now.
First look at the picture:%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(13)
Do you see the ID in the 1st column?
And my question is:
How can I get the bound with ID and Name
For example: I known the ID which is 50010202 the Name is N1, and How can I get the Bound.
Please help me to solve it .
Thank you.

Read the excel into DataTable and use the select method to read the Bound value like below
foundRows = DataTable.Select(“ID = 50010202”)

If not foundRows is nothing
BoundValue = foundRows(0)(3)

0 - represents first row
3 - represents 4th column

Regards,
Karthik Byggari

I know this but I want get the bound with two option
one is ID and other is Department
I tried this
Data Table.Select(“ID=‘50010202’,Department=‘D1’”)(0)(3).ToString
but it does not work.

In select the expression should be like this

Select(“ID=‘50010202’ AND Department=‘D1’”)

Regards,
Karthik Byggari

1 Like

Thank you Thank you
I solve it

Very appreciate!!!

1 Like

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