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.

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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.