DataTable.Select() finding data in all columns...
-
I'm trying to search a DataTable, with .Select(), to find all rows with a certain string in any of the columns.I basically want to match a string *string* with the data in any of the columns in a particular table. I've tried, simply, table.Select( "'*' LIKE '*" + searchTerm + "*'" ) and while that runs with no errors, it also returns nothing. Had one idea, it's selecting fom all columns, but all columns do not have the sarchTerm, thus nothing returns. How can I tell it to return rows where ANY column has the searchTerm, while not excluding because the other columns do not have the searchTerm?
A soft glow comes from the pit in the darkness. The clicking noise become faster - and louder. A wind begins to stir up from the pit, as the creature flexes it's wings, preparing for flight. You stare into the pit, and hear a voice say in your mind, "If you survive the encounter, declare it to the world." The Code Demon Rises.
-
I'm trying to search a DataTable, with .Select(), to find all rows with a certain string in any of the columns.I basically want to match a string *string* with the data in any of the columns in a particular table. I've tried, simply, table.Select( "'*' LIKE '*" + searchTerm + "*'" ) and while that runs with no errors, it also returns nothing. Had one idea, it's selecting fom all columns, but all columns do not have the sarchTerm, thus nothing returns. How can I tell it to return rows where ANY column has the searchTerm, while not excluding because the other columns do not have the searchTerm?
A soft glow comes from the pit in the darkness. The clicking noise become faster - and louder. A wind begins to stir up from the pit, as the creature flexes it's wings, preparing for flight. You stare into the pit, and hear a voice say in your mind, "If you survive the encounter, declare it to the world." The Code Demon Rises.