OverWrite the existing value in the database

Question

0.00/5 (No votes)

See more:

Hello! Here a project on which I am working on currenty...what it does is it asks for the login information like username and password from user and verifies it with the values in the database..and if it matches with the values in the database it opens 2nd window where It gives user to change password.....
What I have done till now is stared a database named DB.mdf which has a table named userInfo_table and connected with the program...I am able to validate the user name and password from the user and open the second window but now I cant overwrite the value of password in the database so that from next time when user Logins user have to insert the new password...
Database details...
database name -- DB.mdf
Table name -- usrInfo_table
Columns -- Username and Password

Please download and evaluate this porgram...
http://www.quickfilepost.com/download.do?get=ed85ecd13317881e3d51a4abd335bf74

Posted 12-Feb-10 0:39am

Binayak Upadhyaya

Add a Solution

4 solutions

Solution 1

Since you have already verified the user, I assume you are familiar with ADO.Net. You have go on the similar lines as you did for validating user name and password. Only difference being, for changing the password for the user, you would need to execute an update command. Something like this:

Update yourTable
set Password = 'changedPassword' 
where userName='currentUserName'

Posted 12-Feb-10 0:59am

dan!sh

Solution 3

In that case you should read a book/tutorial on ADO.Net. .Net frameworkd provides a lot of classes to perform updates in the database. In your case, you would need OleDbConnection and OleDbCommand classes. Along with that you would also need to use CommandParameters. Have a look a these and you can work through.

Posted 12-Feb-10 1:29am

dan!sh

Solution 2

No! sorry I am not familiar with ADO.Net...I have reached to here afer reading some books and watching Utube videos...Please Look at my work till now from the link i gave......

Posted 12-Feb-10 1:10am

Binayak Upadhyaya

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)

Murugesan Solaiyappan · Accepted Answer · 2010-02-12T02:22:00

1.add one class file(.cs) in your project
2.create a object in login form for that .cs file
3.declare the variable like
"public static string strUsername;" in .cs file
4.while user login,on button click(login button) assign the username in that variable("strUsername")
5.in second form(for change the password form) here also create object for .cs file
6.write update query like"update usrInfo_table set password='"+ txtpwd.text+"' where username='" + objcs.strUsername +"'"

objcs-->objects of cs file

Regards
S.Murugesan
Software Engineer
Gratiff solution and systems