how to save data from web form

• • Reply

  13 years ago

  by sroy20

  subhasish roy

  , United Arab Emirates

  Joined 13 years ago

  I am developing a website which also contains data to be entered by visitors, in a Booking form and Enquiry form.

  What I would like to know is:

  How do I save the information entered by visitors, so that it can be viewed in the backend for future use. Also how to send an automated emails response after the forms are filled up.

  Many thanks in advance!!!

   

  Report abuse
• • Reply

  13 years ago

  by radha_telanakula

  Radha

  , India

  Joined 14 years ago
  For saving you need to insert all the values in the database.
  First establish a connection like this.
    Dim con As New SqlConnection("user id=sa;pwd=mssi@123;server=PHPDEVELOP;database=onlinegre")
  Next write the sqlcommand for inserting.
  
  
  For mail sending
  
  Imports System.Web.Mail
  Dim mail As New MailMessage
          Dim mailvalue, password As String
          mailvalue = emailid.Text 'emailid.Text is the name of text box in which you enter mail address
          mail.To = mailvalue ' to whom you sent.
          mail.From = "[email protected]"
          mail.Subject = "Your Gre Online Login Information"
          mail.Body = "Welcome Your Login id is:" & emailid.Text
          SmtpMail.SmtpServer = "materialsoft.com.xohost.com" 'your real server goes here
          SmtpMail.Send(mail)
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Report abuse