Reset password and to send the new password

First of all you need to verify the security question and answer from user and pass the question,answer to the following stored procedure. It will update random password and returns password, which you can sends to customer in email.

CREATE PROCEDURE [dbo].[prc_UpdatePassword]
(
	@secretquestion varchar(100)='',
	@secretanswer varchar(100)='',
	@ReturnVal varchar(10) out
)
as
begin
if exists (select * from tbl_MUSR where secretquestion=@secretquestion and secretanswer=@secretanswer)
Begin
			--Generate Random Password
			Declare @Length int
			DECLARE @strPassword varchar(32)
			DECLARE @counter smallint
			DECLARE @RandomNumber float
			DECLARE @RandomNumberInt tinyint
			DECLARE @CurrentCharacter varchar(1)
			DECLARE @ValidCharacters varchar(255)
			SET @ValidCharacters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-=+&$'
			DECLARE @ValidCharactersLength int
			
			declare @iLicence int
			declare @iInsured varchar(10)
			
			SET @ValidCharactersLength = len(@ValidCharacters)
			SET @CurrentCharacter = ''
			SET @RandomNumber = 0
			SET @RandomNumberInt = 0
			SET @strPassword = ''

			SET NOCOUNT ON

			SET @counter = 1
			set @Length=8
			WHILE @counter < (@Length + 1)
			BEGIN
					SET @RandomNumber = Rand()
					SET @RandomNumberInt = Convert(tinyint, ((@ValidCharactersLength - 1) * @RandomNumber + 1))
					SELECT @CurrentCharacter = SUBSTRING(@ValidCharacters, @RandomNumberInt, 1)
					SET @counter = @counter + 1
					SET @strPassword = @strPassword + @CurrentCharacter
			END
			update tbl_MUSR set Password=@strPassword where secretquestion=@secretquestion and secretanswer=@secretanswer
			set @ReturnVal=@strPassword
end
else
	set @ReturnVal='Not Found'
end

First of all you need to verify the use authentication using any security question answered by user at registration time and then generate some random code
update database with that code and then send mail to the user.

to send email check this.
How to send email through asp.net[^]

First of all you need to verify the use authentication using any security question answered by user at registration time and then reset his/her password

OR

You can directly send a email of new password to his/her mail id given on registration time.

For resetting password you can just fire a UPDATE query to you db and set new password on the basis of the user criteria matched on above any condition

For Reset Password, you can reset it with user's birth date or you can also genrate random word using coding to reset the password.



For Sending Email Please see this link it will help full to you..
How to send A E-Mail From Your ASP.NET web Application...?[^]

you should need to update password in your database also and send a mail that specifies new password.
to send mail use

public static Boolean SendingMail(string From, string To, string Subject, string Body)
   {

           try
           {
               MailMessage m = new MailMessage("uid", To);
               m.Subject = Subject;
               m.Body = Body;
               m.IsBodyHtml = true;
               m.From = new MailAddress(From);

               m.To.Add(new MailAddress(To));
               SmtpClient smtp = new SmtpClient();
               smtp.Host = "mail.google.com";

               NetworkCredential authinfo = new NetworkCredential("uid", "password");
               smtp.UseDefaultCredentials = false;
               smtp.Credentials = authinfo;
               smtp.Send(m);
               return true;




           }
           catch (Exception ex)
           {
               return false;
           }
       }