[VB2008/Net framework 3.5] Stuck, need some code suggestions/ideas for these problems

Hi there guys, to be quite honest with you i'm going to come straight out and say that i have tried my best to do the code required for the scenario required but just cannot seem to do get it right. Any help would be greatly appreciated.

Basically i have three tables
tbl_users
tbl_shares
tbl_shares_bought

what i need to do is a module that when called will grab the information out of these tables,using the person who is logged in via the tbl_users then add the share from the share table that was selected in the datalist view on a form that they came from and then add that share from the share tbl and add it to the users account, which is linked by relationship into tbl_shares_bought.

Also i'd like to know what the code would be to use a form to look up if a certain peice of text exists in a table upon pressing a button on that form and then moving on depending on a if statement, i've got most of the code i just need the database part.

Any help would be really appreciated..

Thanks

Hottwire

You should follow the Database FAQ link in my signature and check out the ADO.NET resources, including a tutorial and code examples. It's then just a matter of changing the appropriate names to fit your project. There are also Walkthrough and Video links in my signature that lead to MSDN.