Search for a particular number in data table ,If found return that value or a Boolean value.How to achieve this
Do you want to check in any particular column or complete data table.
Is the number is a part of text or full text.
That number is in first column and data table will have only one column.That number is full text only:
Need to check whether 12345 is present in data table first column or not
you can get with below code:-
bool ValueExists = YourDatatableName.AsEnumerable().Any(function(row) valueToSearch = row.Field(Of String)(“Column1”))
Find attached sample and let me know
nDivyasAmpleDtColValSearch.xaml (7.9 KB)
Use Assign Activity -
if number is stored in an variable and type is Integer
dataRowsArray = YourDataTable.Select(“Column1=” + SearchNumber)
If number is stored as a string
dataRowsArray = YourDataTable.Select(“Column1=” + “’” + SearchNumber + “’”)
if dataRowsArray.Length > 0 then number is found else not found.
Thanks… It’s working…
If i consider datarowarray as an array then type conversion error populated
It is an array of DataRow data type.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.