How do I programatically retrieve and update data within an .mdf database within my solution

Question

Hi All.

Am hoping you can help out a beginner here. I am using VS 2008 express, with C#.net.

I have created a DB via the IDE and it is connected to a set of field on my form. I want to be able to update the data within the database, and selected to update the form programatically...ie based on events within the program.

I have a beginners book that shows some very basic DB stuff, but nothing programatically...ie using update <table> set <column> = <value> where <column> = <value> etc.

Will I need to create a  new DB class that takes care of all DB interaction, even though the DB is not remote, ie I am automatically connected via the solution.

I hope this makes sense and you can push me in the right direction.

Many Thanks
Gary