Where is your try-catch-finally block ?
What exception do you receive. "not able to change the password"
doesn't really tell us anything about the error your receive (if at
all you do).
On Dec 3, 7:37 pm, "Mohammad Irshad Ali Ansari"
<[EMAIL PROTECTED]> wrote:
> hello,
> i have got one problem, i m not able to update the password or u can say
> that i m not able to change the password help please.
> and i m a beginner so please explain me what should i have to do.
> and thanks in advance.
> please help me
>
> string conString = ConnectionClass.MethodConnectionString();
> OleDbConnection conn = new OleDbConnection(conString);
> if (conn.State == ConnectionState.Open)
> {
> conn.Close();
> }
> //string updatePassword = @"Update LoginTable set password =
> '" + strConfirmPassword + "'" + "where username = '" + lblUsername.Text +
> "'";
> string updatePassword = @"Update LoginTable set Password =
> 'admin' where UserName = 'irshad'" ;
> conn.Open();
> OleDbCommand cmdPass = new OleDbCommand(updatePassword,
> conn);
> cmdPass.ExecuteNonQuery();
> conn.Close();
> MessageBox.Show("You have successfully Change ur password");
>
> Best regards,
> Mohammed Irshad
