Hello could you help me how I can include the condition for check if there is code different of “BD” or “00” for all rows in the table and other condition for check if the table has only one specific code for all rows.
Example 1: Table: DT_SAMPLE
codes: FA, AC, BD
Check if there is the code different of “BD” or “00” for ALL lines.
Example 2: Table: DT_SAMPLE2
codes: BD, BD, BD.
Check if there is only the codes “BD” for rows.
Hello, I´d like to know if for all rows in Data Table activity DON´T have one specific code (“BD”).
For example , I have 03 lines in Data Table (BD, 00, BD) and I need to do something ONLY if all rows are “BD”. Which condition I can to use?
My variable is dt_sample (DataTable type) and I put the condition as:
For each row in dt_sample
If
dt_sample.AsEnumerable().All(Function(a) a.ToString.Contains(“BD”))
the Table has BD, BD, BD codes but is not appearing the the message that I included.
Hello, I don´t know the quantity of rows and only I´d like to know if exist only the “BD” Code for all rows.
Could you please put one example for me? thanks
I put this in the condition and and into the then one message box for show me “OK”
but is not working.
Before I confirmed that I have the BD, BD and 00.
One suggestion?
the condition row.ItemArray.All(Function(c) not c.ToString.Contains(“BD”))
appear the message box for the others two rows that the code is “BD”.
I need that if appear the message only if all line are BD.
The condition is correct but if I put the message box, is appearing yet with the quantity of rows that I have with “BD”.
I have 03 lines (00, BD, BD) is appearing 02 times the message box but I need know when is not exist all rows with “BD”. How can I do please?