Searching through a dataset

[KevoMee]

Hi, i have a created a dataset using a table from my database. I now want to search this dataset and am wondering if there is anyway in C# where I can do it by using something like a LIKE command in SQL.

So if I search for "car" it will also return things like "racecar" or "bigcar" etc.

 

[Guest_imported]

http://www.sqlteam.com/item.asp?ItemID=1876

Has a good example in classic ASP. You'll understand the SQL syntax pretty easily. Instead of creating new tables in SQL, however, you'll be better off doing them in the .NET DataSet object.