How do I do a DB search?

[veryvbnooby]

I'm new here so hi everyone!
I'm also very new to VB, I've taken a few classes in it but I think this project I'm doing is pushing my abilities a bunch. First off I'm using MS Visual Studio 2010 and trying to search a MS Office 2007 access DB. I no doubt will have a whole host of questions beyond this one. This project will be my first 'public' release of anything....if I can get it to work right. So now to the question.

I have the DB linked to my project and in a test I got it to display in grid view but I want to make this search-able displaying just the relevant info searched for instead of displaying all the DB info. How does one setup a search like this? I don't want to use the grid view, I just want to display the searched for info. If someone knows of a nice step by baby step tutorial on how to do this I would be most appreciative. I've tried goggling this but I'm not sure of what to search for.


Thank You

veryvbnooby

[proneal]

http://www.techotopia.com/index.php/...g_Visual_Basic
That is a tutorial.
I hope it shows ability to search like you want.

[veryvbnooby]

Thank You!
That help a lot. Sorry for the delay getting back but I ran into a problem. For some reason when using the 32 bit Visual Studio in a 64 bit environment(Win 7) the Db wouldn't display when I built the app. I'm using my Win xp partition now for the coding. Is there some setting I need to set in VS to fix that?

So I got the search working but I ran into a problem. I think first I should explain what I'm doing for this project. I'm trying to make a search-able DB for the crafting professions in a MMO. This will be a rather large DB when I'm done with it. The way I want to search it is to check a radio button for the major stat your looking for(dexterity, strength, ect...) and the item you want it on say boots for example and have it display all the info under that item that has that stat.
The problem I ran into is I have multiple cells that have say dexterity in them and some cells that have multiple stats say strength and dexterity. If there is only one cell with only that stat then it displays. So how do I do a wild card search and how do I display the info from multiple cells from that search?

If your asking why I want to do this the answer is this: A learning experience that is some what sorta kinda useful in an arcane way. Mostly a learning exercise though.


Thank You