Windows Form Database Help

[acestu]

Hi,
I have just started using visual studio 2010 and I am trying to make a small contacts database.

I have watched several videos on youtube and the basic database construction is quite easy, however I would like to add
searh for first name and second name etc functionality, and the videos don't seem to show you how to do this.

There are plenty of videos on youtube of what i want but it is students showing off their work and they don't explain anything.

I have bought books but they don;t show what I am trying to do.

If anybody has any links to a ggood tutorial I would be very grateful...

Thanks
In Advance
Acestu

 

[jmcilhinney]

You will probably have seen examples of what you're trying to do in various places but you just didn't realise it. All you need to do is to execute a query with a WHERE clause, which is used to filter the results. If you want to filter in several different ways then one option is to use several queries with different criteria in the WHERE clause.