i want to change pwd and same time updating my db.

Question

0.00/5 (No votes)

See more:

hi..here i want to change my password.i have username,password,new password and confirm password are textboxes.after running the gm.i didn't get any error message but it doesn't update my database.here it is my code.so please help me.

C#

Imports System.Data.OleDb
Imports System.Data

Partial Class update
    Inherits System.Web.UI.Page
    Dim cn As OleDbConnection
    Dim cmd As OleDbCommand
    Dim dr As OleDbDataReader
    Dim n As Integer
    Dim Adapte As OleDbDataAdapter = New OleDbDataAdapter

    Private Property txtnewpass As Object

    Private Property txtconfirmpass As Object

    Private Property txtuserid As Object

    Private Property txtoldpass As Object

    Private Property count As Integer

    Private Property newPass As Object

    Private Property ex As Exception

    Private Property username As String

    Private Property password As String

    Private Property conPass As Object

    Private Property this As Object

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Try
            cn = New OleDbConnection("data source=C:\Users\Administrator\Desktop\login1.mdb;provider=Microsoft.Jet.OLEDB.4.0")
            cn.Open()

            username = TextBox1.Text
            password = TextBox2.Text
            newPass = TextBox3.Text
            conPass = TextBox4.Text


            cmd = New OleDbCommand("select username,password from login where username = @username and password = @password", cn)
            cmd.Parameters.AddWithValue("@username", this.TextBox1.Text)
            cmd.Parameters.AddWithValue("@password", this.TextBox2.Text)
            dr = cmd.ExecuteReader()
            dr.Read()

            If (dr("username").ToString() <> String.Empty & dr("password").ToString() <> String.Empty) Then


                If newPass.Trim() <> conPass.Trim() Then
                    Label5.Text = "New Password and old password does not match"
                End If
            Else
            End If

            cmd = New OleDbCommand("UPDATE login SET passwd = '" + TextBox3.Text + "' WHERE username ='" + TextBox1.Text + "'", cn)
            cmd.Parameters.AddWithValue("@newPasss", this.TextBox3.Text)
            cmd.Parameters.AddWithValue("@username", this.TextBox1.Text)
            cmd.Parameters.AddWithValue("@password", this.TextBox2.Text)

            Int(count = cmd.ExecuteNonQuery())
            If (count > 0) Then

                Label5.Text = "Password changed successfully"

            Else
            End If
            Label5.Text = "password not changed"
   
     Catch ex As Exception
       End Try     

    End Sub

    Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
        Session.Abandon()
        Response.Redirect("Login.aspx")
    End Sub
End Class

Posted 26-Dec-13 19:30pm

Member 10478580

Updated 26-Dec-13 19:35pm

Tom Marvolo Riddle

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Dec-13 1:42am

Please debug and see where exactly is the Problem.

Member 10478580 27-Dec-13 2:36am

there is no prob,it doent display any error msg,warngs etc..

King Fisher 27-Dec-13 1:44am

debug it .you can find?

Member 10478580 27-Dec-13 2:38am

yes idid.but it doent disply any error.when i enterd values after debugging,my db cant update those details

King Fisher 27-Dec-13 4:55am

does it say this "password not changed"

Member 10478580 27-Dec-13 5:01am

there is no error msg or any type of msg afetrr debugging.

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-12-26T19:47:00

Solution 1

One Problem I can see

The Update query...

VB

cmd = New OleDbCommand("UPDATE login SET passwd = '" + TextBox3.Text + "' WHERE username ='" + TextBox1.Text + "'", cn)
cmd.Parameters.AddWithValue("@newPasss", this.TextBox3.Text)
cmd.Parameters.AddWithValue("@username", this.TextBox1.Text)
cmd.Parameters.AddWithValue("@password", this.TextBox2.Text)

should be like below...

C#

cmd = New OleDbCommand("UPDATE login SET passwd = @newPasss WHERE username = @username AND passwd = @password", cn)
cmd.Parameters.AddWithValue("@newPasss", newPass)
cmd.Parameters.AddWithValue("@username", username)
cmd.Parameters.AddWithValue("@password", password)

This will help you to restrict SQL Injection Attack.

But you should not directly store the Password, instead change your logic to implement some Encryption so that Password will be protected. Inserting plain text Password is not recommended.

Posted 26-Dec-13 19:47pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Updated 26-Dec-13 19:49pm

v2

Comments

Member 10478580 27-Dec-13 2:35am

thanku,still it doesn't work,no error msg displayed,and my db cant update the details.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Dec-13 2:42am

What is the value of count in below line...

If (count > 0) Then
Label5.Text = "Password changed successfully"

Member 10478580 27-Dec-13 2:50am

i'm assgned this value to the command

Member 10478580 27-Dec-13 2:51am

Int(count = cmd.ExecuteNonQuery())

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Dec-13 2:59am

I am asking what is the value of count after you assign that?

Member 10478580 27-Dec-13 3:59am

i thnk 2 times it vl execute in my code.so it's value is 2

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Dec-13 5:00am

So, if its value is 2, then it should go inside if block and show success message in Label.

If (count > 0) Then

Label5.Text = "Password changed successfully"

Else

Member 10478580 27-Dec-13 5:26am

can u pls explain me whats wrong vth my code

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 27-Dec-13 5:54am

That you can know better if you can debug and see. If the count is greater than 0 then it is updating the password for sure.

If it is not doing any operation, then it would always return 0.

While debugging each line, you can know what is the issue. If each line executes as expected, then it is fine. If it is going to Catch Block, then there is a problem. Read the Exception carefully and search that in Google directly. You will get many answers for that Exception.

So, keep trying and debugging. :)

Member 10478580 28-Dec-13 7:21am

ya.after doing performance analysis,the count can exucete in 10 times vth 0 valu at alla times..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 28-Dec-13 7:58am

Ok. That means the value of count is 0, right? Do you get any exception?

Member 10478580 28-Dec-13 8:11am

noo...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 28-Dec-13 8:24am

I would suggest you to read more on how to execute query in code, how to connect to database, about connection strings and all. May be your connection string is wrong. But I am not sure. I am not at your end.

If you debug your code, you will definitely get the hint.

Member 10478580 28-Dec-13 7:29am