i have a doubt

kiran kumar

if a user is registered at the website that particular user information i.e user name and password is sent automatically to the user's email...how this process gets done????one more thing i have created a .cs file named registration.cs for inserting user records into database now the thing is where should i write the email script to send that information to the user should i need to continue in the same registration.cs file or should i need to create a separate .cs file to write the email code to get the things done

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa16y ago
Accepted answer
Hi Kiran,

You have to programmetically send an email once the user registration is done. There are plenty of c# examples on the web to send emails.

If you want you can write the sending email part in the same .cs file. But it's nice to write it in a separate .cs file.

If you have any other problem please ask.

If you find my answer useful, please check 'Do you like my answer' checkbox.
mihir soni16y ago
if you do not have any mail server than you can use smtp server of gmail which is free.

and if your website hosting provide smtp server than you can use their email server.
kiran kumar16y ago
i am using iis
Nilanka Dharmadasa16y ago
Hi kiran,

This example uses simple mail transfer protocol.

Mail me with your exact requirement. (I mean what's the mail server that you use.)
kiran kumar16y ago
do i need to install smtp server???or jus use the asp.net application server...or can i go for iis

Nilanka Dharmadasa16y ago

Hi Kiran,

E mail sending part can be done as follows.

First add a class file (.cs file) named 'EmailSender' to your project.

Then write the code as follows.

 
using System;
using System.Collections.Generic;
using System.Text;

namespace WindowsFormsApplication2
{
    public class EmailSender
    {
        System.Net.Mail.SmtpClient smtpConnection;

        public EmailSender()
        {
            smtpConnection = new System.Net.Mail.SmtpClient();
            smtpConnection.Host = "mail.usermail.net";//Your mail server's ip or name.
            smtpConnection.Port = 25;//The port
            smtpConnection.Credentials = new System.Net.NetworkCredential("username", "password");//Username and password to access mail server
        }

        public void SendMail(string Username, string password, string email)
        {
            string mailbody = String.Format("This is your account details. Username: {0}, Password: {1}", Username, password);
            System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
            message.To.Add(email);
            message.Subject = "Your account details";
            message.From = new System.Net.Mail.MailAddress("[email protected]");//Give your from e mail address here
            message.Body = mailbody;               
            smtpConnection.Send(message);
        }
    }
}

Then call the 'SendMail' method in your previous class after inserting data to the databse.


        ........
        ........
        cmd.ExecuteNonQuery();
        con.Close();

        EmailSender obj = new EmailSender();
        obj.SendMail(CreateUserWizard1.UserName, CreateUserWizard1.Password, CreateUserWizard1.Email);

kiran kumar16y ago
yes it worked fine i could able to insert userid into my db......now i want to send this particular information in email to the user...
Nilanka Dharmadasa16y ago
Hi Kiran,

Add the code in red color to your code.

SqlParameter uid= new SqlParameter("@userid",SqlDbType.NVarChar,50);
uid.Value = newuserid.ToString();
cmd.Parameters.Add(uid);

Check and let me know the result.
Lalit M16y ago
you can try this code sample

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.Net.Mail;

public static void sendEmail()
        {

        string fromEmail = "";//sending email from...
        string ToEmail = "";//destination email
            string body = "";
            string subject = "";

            try
            {
                SmtpClient sMail = new SmtpClient("");//exchange or smtp server goes here.
                sMail.DeliveryMethod = SmtpDeliveryMethod.Network;
                //sMail.Credentials = new NetworkCredential("username","password");this line most likely wont be needed if you are already an authenticated user.
                sMail.Send(fromEmail,ToEmail, subject, body);
            }
            catch(Exception ex)
            {
               //do something after error if there is one
            }
}
kiran kumar16y ago
MembershipUser newuser = Membership.GetUser(CreateUserWizard1.UserName); Guid newuserid = (Guid)newuser.ProviderUserKey; SqlConnection con = new SqlConnection("Data Source=KIRAN\\SQLEXPRESS;Initial Catalog=kiran;Integrated Security=True"); con.Open(); string querystring; querystring = "insert into reg(username,password,email,securityquestion,securityanswer,userid)values(@username,@password,@email,@securityquestion,@securityanswer,userid)"; SqlCommand cmd = new SqlCommand(querystring, con); SqlParameter uname = new SqlParameter("@UserName", SqlDbType.NVarChar, 50); uname.Value = CreateUserWizard1.UserName; cmd.Parameters.Add(uname); SqlParameter pass = new SqlParameter("@Password", SqlDbType.NVarChar, 50); pass.Value = CreateUserWizard1.Password; cmd.Parameters.Add(pass); SqlParameter ema = new SqlParameter("@Email", SqlDbType.NVarChar, 50); ema.Value = CreateUserWizard1.Email; cmd.Parameters.Add(ema); SqlParameter secques = new SqlParameter("@securityanswer", SqlDbType.NVarChar, 50); secques.Value = CreateUserWizard1.Question; cmd.Parameters.Add(secques); SqlParameter secans = new SqlParameter("@securityquestion", SqlDbType.NVarChar, 50); secans.Value = CreateUserWizard1.Answer; cmd.Parameters.Add(secans); SqlParameter uid= new SqlParameter("@userid", SqlDbType.NVarChar,50); uid.Value = newuserid; cmd.Parameters.Add(uid); cmd.ExecuteNonQuery(); con.Close(); } } } and when i debug it says that "Failed to convert parameter value from a Guid to a String".