wat the error you got...
On 12/4/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> okay means i have to add the try catch block, i will and i m getting
> the error of syntax error in update statement
>
> On Dec 3, 11:14 pm, Cerebrus <[EMAIL PROTECTED]> wrote:
> > 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
