?
Solved

String Search in .Net C#

Posted on 2014-04-11
3
Medium Priority
?
260 Views
Last Modified: 2014-04-17
I am needing to ask experts if familiar with being able to add several words into a text box and do a search in .NET with SQL Server backend.  

Is there any info on.  ARe there examples?  How does it work?

in a
Text box:
enter example
 Name phone pet name  

Results would bring back Name phone and pet name and any other fields I need.
0
Comment
Question by:leezac
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39995094
I think we need more information on the structure of your database table(s).
0
 

Author Comment

by:leezac
ID: 39995142
I have not designed tables yet.  Just general question about if doable and how.  I have never done before and think would be complex if a lot of tables.  But suppose code would need to select from all the tables concerned if name is found in one and pet name in another.   I am just not sure how it would work.  Be like a Google search for SQL Server using .NEt.
0
 
LVL 11

Accepted Solution

by:
MajorBigDeal earned 2000 total points
ID: 39995292
Yes this is doable but it might not be the best approach.  SQL Server supports full text searching (via CONTAINS and FREETEXT) which is what I think you are trying to do.  

That said, if  the users know which info represents the pet name versus the phone number then it might be better to provide individual search fields so that your queries could be more structured and efficient.   If they don't know then I can see where you might want to use full text search and just return any hits that you find in the database.
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question