If you are searching only in one field, just use standard SQL command:
SELECT myfield FROM mytable WHERE criteria=searchstring;
If you are searching on the whole row, try this:
using System.Data;
using System.Linq;
DataRow result = (from DataRow r in tableVariable.Rows
where string.Join(",", r.ItemArray).Contains(searchString)
select r).FirstOrDefault();
List<DataRow> results = (from DataRow r in tableVariable.Rows
where string.Join(",", r.ItemArray).Contains(searchString)
select r).ToList();
Haven't tried it though, but I think it is an fast and effective way (not time-consuming).