Connecting Tech Pros Worldwide Forums | Help | Site Map

Help with simple form linked to database

Member
 
Join Date: Feb 2007
Posts: 49
#1: Sep 8 '08
Good Day All!

I have a basic understanding of html/asp et cetera. I am wanting to create an html form/interface that allows a user to enter, for example (first name, last name, donation amount in dollars). Once the user clicks "submit" button, I want that information to be stored into a database (preferrably MS Access 2007). This is where I begin to get clueless.

I can build the interface/form using VWD 2005 (asp), using textboxes for input and a button for submission. I have also built a very basic Access database with fields for firstname, last name, donation). I am having trouble linking the two together for seamless operation. This should be a simple task but I am being frustrated by it.

Any help, examples or resources are greatly appreciated!

Thanks, Mike

insertAlias's Avatar
Forum Leader
 
Join Date: Apr 2008
Location: San Antonio, TX (USA)
Posts: 2,608
#2: Sep 8 '08

re: Help with simple form linked to database


Look up AccessDataSource. Should do what you need.

Alternatively, we have two articles here on Bytes that show another method:
How To Use A Database In Your Program
How To Use A Database In Your Program Part II

And don't forget http://www.connectionstrings.com for your connection string.
Reply