biran

Hi all,
i am having a problem please help me.
actualy i am trying to change password.
i tryed like this but its give me update syntax error.
..............................................
private void ChangePassBtn_Click(object sender, EventArgs e)
{

if (npass1.Text != npass2.Text || npass1.Text == "" || npass2.Text == "")
{
MessageBox.Show("New password Not match or incorrect entry");
}
else
{
try
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data\\security.mdb;Jet OLEDBatabase Password=computer";
OleDbConnection myConn = new OleDbConnection(strConn);
myConn.Open();
string constr = @"Select userid,password From Admins";

OleDbCommand inst = new OleDbCommand(constr, myConn);
OleDbDataReader reader = inst.ExecuteReader();
while (reader.Read())
{
uid.Text = reader[0].ToString();//uid is hiden tbox
upass.Text = reader[1].ToString();//upass is hidden tbox
}
myConn.Close();
reader.Close();
//
string r1, r2;
r1 = uid.Text;
r2 = upass.Text;

if (r1 == userid.Text && r2 == password.Text)
{
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=data\\security.mdb;Jet OLEDBatabase Password=computer";
OleDbConnection myCon = new OleDbConnection(strCon);
myCon.Open();
string strUpdt = "UPDATE admins SET password='" + npass1.Text + "'";
OleDbCommand myCommand = new OleDbCommand(strUpdt, myCon);
myCommand.ExecuteNonQuery();
MessageBox.Show("Password Successfully changed");
myCon.Close();

}
else
{
MessageBox.Show("Error");
}
}
catch(Exception ed)
{
MessageBox.Show("error:\n" + ed.ToString());
}
}
}
......................................................
please as sooon as posible feedback me.
thank you

nnxion

Code tags please.

__________________
"Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for."
-- Socrates

biran

hi nnxion
i am doing this for 2 days but i am failed please if you have idia give me solution.
thanks

nnxion

Syntax error of what? These are code tags:

__________________
"Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for."
-- Socrates

biran

hi all,
thanks for not supporting.
finelly, after 3 dyas i did it. and thanks for question viewer.

thanks

nnxion

Hey, it's your problem, if you don't specify the problem then don't get pissed at us. If you tried it for 3 days, then you had enough time to specify what the problem was, we don't have your environment set up, so it takes us a lot of time, and you know what they say: time is money.

__________________
"Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for."
-- Socrates

biran

nnxion
i already wrote about error ->update syntax error.
i change database field it was userid and password and i changed userid to users and password to pass so its same cod work properly. i don't know why database coused this code.
anyway thank you for you aprociation.