How Do I Save a c# Generated Random number To Database

Question

0.00/5 (No votes)

See more:

Hello,

i am trying to develop a password recovery system, where when the user click on the "forgot you password" link, it generates a random number to the user's email and the user gets verified.

i have successfully written the code in c# that generates the random number and sends it to the user's email but am now trying to figure out how to save the random number that was generated into the database.

Thanks in advance

Posted 2-Apr-14 13:38pm

Member 10658074

Updated 2-Apr-14 13:39pm

v2

Add a Solution

Comments

PIEBALDconsult 2-Apr-14 20:59pm

Save it to the database first, maybe make sure it also has a time limit, and can only be used once.

Member 10658074 3-Apr-14 4:48am

Hi, that's what i plan to do but don't have a clue how to go about it.

ZurdoDev 2-Apr-14 21:28pm

Where are you stuck? Interacting with a database is trivial and in most applications.

Member 10658074 3-Apr-14 4:52am

Hello,
i am generating a random number then emailing it to a user who then inputs it in a another form for verification, if the numbers are the same the user is allowed to access the next form, the problem now is i want to save the random numbers that are generated, put a time limit with restrictions that allows a user to create a random number only twice in a day and i dont know how to do that.
At the moment i can generate the random number and send to an email.

ZurdoDev 3-Apr-14 7:04am

Do you know how to write to a db?

Member 10658074 3-Apr-14 7:42am

yes i know

ZurdoDev 3-Apr-14 7:47am

So then you aren't stuck there. So, where are you stuck? Give us something precise so we can help.

Member 10658074 3-Apr-14 8:01am

is it possible for me to store the random number in the database then send it to an email address from the database?

ZurdoDev 3-Apr-14 8:02am

Sure. Create a field in a table and store it there. As someone else suggested perhaps even add a time stamp so that it is only valid for a given time. However, none of this is just built-in. You'll have to write the code for all of it.

Member 10658074 3-Apr-14 8:07am

okay, let me try to do that and get back with my outcome.

Member 10658074 8-Apr-14 13:14pm

Hello Ryan, thanks a lot, i have it working now.

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)

Peter Leow · Answer 1 · 2014-04-02T14:34:00

Solution 1

Use sql insert, refer:
Using Parameterized queries[^]

Posted 2-Apr-14 14:34pm

Peter Leow