Hello, I want to create a function that checks if in an excel Data table in a row the cell in column A is filled + in column B if the cell says “order executed”. How do I write this together in one if statement? Thank you!

Check two columns in datatable

Laurentiu_Mihai (Laurentiu Mihai) November 15, 2022, 6:23am 7

Yes, there is:

dt.AsEnumerable.Where(function(x) x(0).ToString.Trim.Contains(DateTime.Now.ToString(“dd/MM/yyyy”)) andAlso x(1).ToString.Trim.ToUpper.Equals(“ORDER EXECUTED”) ).CopyToDataTable

Topic		Replies	Views
Identify empty cells in DataTable Help datatable , excel , activities , question	6	2080	November 21, 2019
Check if a datatable contains rows with Null or Blanks in any Column/Cells Activities datatable , excel , activities , question	2	4887	May 10, 2021
How to Check Excel 2 null or empty Columns Academy Feedback	13	2667	April 23, 2019
Condition to check the column is blank or not in datatable Studio datatable , studio , question , linq	5	400	January 15, 2024
Query to remove datatable Activities excel , activities , question	7	345	June 6, 2023

Check two columns in datatable

Related topics