Hi, I would like to filter the rows.
gue.Select("[Client] like ‘"+Name+"’ AND [Agent] like ‘DB2’ AND [Type] like ‘"+service1+"’").CopyToDataTable
The agent is not fixed. It’s either ‘DB2’ or ‘SQL Server’.
So when I hardcoded the agent to be ‘DB2’, the error was thrown to the assign that the source contains no datarows.
I would like to look for this row this value, if it is not true, find another value.
Below is a sample of the dt
I tried this : serviceCatalogue.Select("[Agent] like ‘SQL Server’").Length > 0 - but does not work
Thank you xoxo