Member Avatar for scottmichael

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.

  • 3 Contributors
  • 2 Replies
  • 83 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Hosam Kamel
Member Avatar for SheSaidImaPregy

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.

Member Avatar for Hosam Kamel

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.