How to check if datatable output column field contains specific text like yes or no

How to check if datatable output column field contains specific text like yes or no.if yes need to get column names

the question can be understood in many directions. May we ask you to illustrate it with some samples. Thanks

For eg we have single row data with column names.for some column it may be yes data for some it may be no data.needa to fetch column name which has no data and assign to a string

For DataColumns
arrNoColNames = YourDataTableVar.Columns.Cast(of DataColumn).Where(Function (x) x.ColumnName.ToUpper.Contains(“NO”)).toArray

For a datarow (the first one)
arrNoColNames = YourDataTableVar.Rows(0).ItemArray.Where(Function (x) x.ToString.ToUpper.Contains(“NO”)).toArray

feel free to modify and use other methods e.g. StartsWith, EndsWith…

Hello @vnsatyasunil

You can refer to the below post. Loop through each row and pass the row number in the expression(can use a counter variable). Then it will give the column index

Here i got above screenshot output in datatable.
I need to read that row data and if it is “no”,i want to get that particular column names which has value “no”.

Can anyone help please