Syntax error in update statement

here is the solution:

String userid = username.Text;
                String password = pwd.Text;
               String date1=date12.Text;
               String report1 = report.Text;
                OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\divyapc\My Documents\CRPDatabase.accdb;
    Jet OLEDB:Database Password=divya6");
                MessageBox.Show(userid);
                OleDbCommand cmmd = new OleDbCommand("UPDATE trialtable SET userid=@userid, [password] = @password,testreport= @report1,date12= @date1 where userid = @userid");
                cmmd.Parameters.Add("@USERID", OleDbType.VarChar).Value = userid;
                cmmd.Parameters.Add("@PASSWORD", OleDbType.VarChar).Value = password;
                cmmd.Parameters.Add("@TESTREPORT", OleDbType.VarChar).Value = report1;
                cmmd.Parameters.Add("@DATE12", OleDbType.VarChar).Value = date1;
                conn.Open();
                cmmd.Connection = conn;

                 int temp = cmmd.ExecuteNonQuery();
                    if (temp > 0)
                    {
                        username.Text = null;
                        pwd.Text = null;
                        MessageBox.Show("Record Successfuly updated");
                    }
                    else
                    {
                        MessageBox.Show("Record Fail to Added");
                    }

                    conn.Close();
                }

Solution 1 seems a good start.

Moreover, if userid column in your database is primary key, I doubt you will be able to update it.

Maybe you can try:

OleDbCommand cmmd = new OleDbCommand("UPDATE trialtable SET password = @password, testreport = @testreport, date12 = @date12 where userid = @userid", conn);

Hope this helps.

there's an unnecessary bracket before the double quotes at

...@userid)"

i.e: it should be

@userid"

There might be error in your naming conventions of you query parameters. Use following one instead,

cmmd.Parameters.Add("@userid", OleDbType.VarChar).Value = userid;
cmmd.Parameters.Add("@password", OleDbType.VarChar).Value = password;
cmmd.Parameters.Add("@testreport", OleDbType.VarChar).Value = report1;
cmmd.Parameters.Add("@date12", OleDbType.VarChar).Value = date1;

-KR