Newbie: ASP.net page that can display an Access 2003 table, and save any changes to it + new records.

Hi,

I figured i'd teach myself asp.net while writing an application for a part of our company. I've got a decade of C++/ASP Classic experience behind me but no .net. i'd appreciate any pointers and (tidy) sample code to get me going subject to the specs below...

Thanks!

------

I would like to create an ASP.net page that lets the user 'edit' or add new items to the table below (note deletions are not allowed due to cascade effect - instead there is a flag for deleted items).

MS ACCESS 2003 TABLE SCHEMA:
tblBrands { BrandName (Text), IsBrandDeleted (Boolean)}


All the table records should be listed in two columns (like the table itself). For field 'BrandName' users should be able to make any changes neccessary in a text box. If needed they should be able to check or uncheck the 'IsBrandDeleted' in the next column for that item. If needed they should also be able to add a new record.

Clicking on a SAVE CHANGES button at the bottom of the page will update the database.

Clikcing on a RESET button will reload the original information from the database.

Clicking on a CANCEL button will forward the users to another page.


Other notes:
There should be some data validation and checking when a user edits/saves.
i.e. They can not clear a Brandname and leave whitespace (there has to be something there), since that is the same as deleting it.