need help in changing the old username and password.. c#

Question

0.00/5 (No votes)

See more:

hello.. i am still a newbie.. but i need help.. i want to change old username and password to a new one..

i am using mysql database..

i want to enter my old username and password in textbox1 and textbox2..

the update username and password in textbox3 and textbox4..

and only one button which is update button..

i did try it but everything changed when i clicked the update button.. i only wanted the specific old username and password to be update..

tq in advance

this is my coding,.. i know based on my coding it will changed all username and password.. but i did not have any idea.. i really need help.. tq

C#

private void button1_Click(object sender, EventArgs e)
        {
            string constring = "datasource=localhost; port=3306;username=root;password=";
         
            string Query = "update login.database set  username='" + this.textBox3.Text + "', password= '" + this.textBox4.Text + "';"; // to insert data to database
            MySqlConnection conDataBase = new MySqlConnection(constring);
            MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
            MySqlDataReader myReader;

            try
            {
                conDataBase.Open();
                myReader = cmdDataBase.ExecuteReader();
                MessageBox.Show("Update");
                while (myReader.Read())
                {

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

Posted 16-Mar-14 20:31pm

Member 10474752

Updated 16-Mar-14 20:32pm

Krunal Rohit

v2

Add a Solution

2 solutions

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)

Krunal Rohit · Accepted Answer · 2014-03-16T20:36:00

First,
In your code, there's a comment for inserting the data, but the code is for updating record. So take care of that. It won't affect your code, but still have some good practice in writing comments for particular piece of code. :)

Second,
if you want to update particular data, you must have where clause in your query.

string Query = "update login.database set  username='" + this.textBox3.Text + "', password= '" + this.textBox4.Text + "' WHERE username='user@user.com'"; // to update the data into database

-KR

sankarsan parida · Accepted Answer · 2014-03-16T20:48:00

You just missed the condition only as per krunal Rohit the query needs a condition for update data otherwise it will affect all rows of table.

For this You design should required 
Old User Name:_______________
Old Password:________________
New username:________________
New Password:________________

It needs more condition only like
 ".......
 WHERE username='"+txtOldUserName.Text+"' and password='"+txtOldPassword.Text+"'"; 

See the concept for what to do

need help in changing the old username and password.. c#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0