Searching MY DB Records with .NET
 

I am new to .net and want to create a search field that querries my SQL database then display results sort of like google. Meaning query all fields for %Like% statements. I am using Visual Studio 2005.

Re: Searching MY DB Records with .NET
 

search your records...

SELECT * FROM stories where title LIKE '%var%' OR story LIKE '%var%'

Simple. can get much more complex if you wish. but you need to be more specific on what you are after.

Re: Searching MY DB Records with .NET
 

you can also use a SQL datasource and assign the select statment mentioned by SheSaidImaPregy to its select query.