Solved

String Search in .Net C#

Posted on 2014-04-11
3
247 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
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 500 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

775 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