Sending reset password mail acknowledgement from main server in vb.net3.5 with ms-sql server 2008

Question

0.00/5 (No votes)

See more:

Hi someone,

I am a beginner and i have got stuck in a small program it will be great help if somebody knows the solution about my problem.

i have to develop a code in vb.net 3.5 with ms-sqlserver2008 in which i am asking for username and password if password goes wrong then the user will hit on forgot password button there he/she will enter his/her email id, then the server will get it change and shoot a mail from there.

Thanks for your support in advance.

Posted 20-Mar-11 22:10pm

RK Anand

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-03-20T22:18:00

Solution 1

Hi,

You actually didn't mention the problem but the steps to do this:
- try to logon
- catch the exception
- if the exception is login failed (18456) then redirect to another window etc and query for email adress
- if the email address is valid, change the password to something new and send the mail using System.Net.Mail

If you want the database server to handle the change then use different credentials for a new connection and for example using a stored procedure make the change to the password and use sp_send_dbmail to send the notification

Posted 20-Mar-11 22:18pm

Wendelius

Updated 20-Mar-11 22:20pm

v2

Comments

RK Anand 21-Mar-11 4:26am

Thanks Mika for your consideration,

Can you please guide me to write code for sending an email from main server to the user when he/she click on the forgot password button.

Wendelius 21-Mar-11 4:39am

Sending an email from the database is very simple. Just configure the database mail and have a look at the examples in http://msdn.microsoft.com/en-us/library/ms190307.aspx

RK Anand 21-Mar-11 6:31am

Hi Mika,
I really appreciate your effort and knowledge.
But i have never used stored procedure, so please can you help me in the programing part.

Wendelius 21-Mar-11 9:08am

Creating a procedure isn't very hard. Have a look at the examples in the documentation: http://msdn.microsoft.com/en-us/library/ms187926.aspx.

After creating the procedure, you can use ExecuteNonQuery (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx) to call it from the client side.