hi there. i am very new to asp.net
i have an IIS server and am building an asp form. what i would like to do is make a form that will send the details for the form to a database and also email the recipient a confirmation.
here is the table for my form, please let me know if this is right:
CREATE TABLE FlyMeToTheMoonResults
(
Id int,
Name varchar,
Age int,
Email varchar,
Phone int,
Address varchar (255),
Postcode varchar (8),
)
the email address my contain numbers as well as letters.
i am used to a lamp emvironment so therefore validation is a new thing to me. altho i have found a validation script for my form.
my greatest need is to know how to make a table (if this one is not right), how to submit my form to that table, how to view the results of that table whenever i want. since the form will deal with the sending of the data on the same page i can sort ofhandle the confirmation message that comes up altho a hint at this wont go amiss.
thank you for your help in this