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] Any suggestions? Thank you xoxo

Use this to get the first row from your dataTable dt1=dt1.AsEnumerable().Take(1).CopyToDataTable() then see if it Contains your string.

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

akila93 September 20, 2018, 2:21pm 14

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

For More related to datatable refer below link

2 Likes

Topic		Replies	Views
Check if row contains string Help	5	8864	July 8, 2019
Check if datatable contains some values and returns true or false? Help	22	27333	July 27, 2019
Finding out if row in data table contains string Help studio	2	5029	April 26, 2019
How do I check if only the first row values in my DataTable contain any empty/null values? Studio	3	1513	May 17, 2022
How to search if a data table contains a variable Studio excel	7	298	October 8, 2023