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.
scottmichael
0
Newbie Poster
Recommended Answers
Jump to Postsearch 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.
All 2 Replies
SheSaidImaPregy
28
Veteran Poster
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.
Hosam Kamel
0
Newbie Poster
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.