Check first row of the table:if yes allow the whole dt through the loop

Help
1

Hi, I would like to check if my first row of the dt contains ‘JAZ’, then allow the whole dt to loop thru in.

I tried this code. But it only lets the first row to loop through in as it contains the word.
dt1.Select(“Details like ‘JAZ’”).Length > 0

image
image623×688 17.2 KB

Any suggestions?
Thank you xoxo

2

You can also try this dt1.Rows(rowIndex)(colIndex).ToString

3

Use this to get the first row from your dataTable

dt1=dt1.AsEnumerable().Take(1).CopyToDataTable() then see if it Contains your string.

4

@PrankurJoshi not sure what you are trying to say. What should I enter as rowIndex and colIndex? and What will the outcome be?

5

dt.Rows(RowNumber)(ColNumber).ToString and you will get the value of that particular cell

image

As you said you would like to check the first row

1 Like
6

@nadim.warsi I tried your method. After it enters If condition, it gives invalid range error.

7

ok do one thing create a new DataTable dt2 from the above exppression for your if, but inside the if use the dt1

8

Hi @sangasangasanga,

If you want to check first row you can directly implement

Convert.ToString(dt.Rows(0)("Details")).ToUpper.Contains("JAZ")

If True the value is available in the first row

9

@nadim.warsi not working still :frowning:

10

what is the issue?

11

@PrankurJoshi @nadim.warsi @akila93
Hi, what you guys suggested, I tried them all. However, It is still not giving me the expected outcome.

13

after you tried this what was the result?

14

HI @sangasangasanga,

dt.Rows(0).ItemArray.Contains("JAZ")
Please refer this xaml file

DataTableRow.xaml (7.6 KB)

For More related to datatable refer below link

2 Likes