Why Update query not working?

Question

I am working with SqlServerCe. The insert query is working properly but the update query gives an exception.

Here is my code:

SqlCeConnection _connection _connection = new SqlCeConnection(@"Data Source=MyDatabase#1.sdf;Password=xxxxx;");
_connection.Open();

cmd.Connection = _connection;
cmd.CommandText = " UPDATE [Solve_Student_question] 
                       SET Answ= '" + ans + "' ,
                           Start_time='" + sTime + "',
                           End_time='" + eTime + "' 
                     WHERE Qno='" + Qno + "' AND 
                           User_id='" + userid + "' AND
                           Exame_id='" + examid + "' sectionname='" + sectionname + "'";
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();

_connection.Close();

It gives an error at the line cmd.ExecuteNonQuery();

An exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in 
System.Data.SqlServerCe.dll but was not handled in user code

You should use prepared statement to avoid all the mixed variable — Prix
– Prix, Commented Mar 19, 2014 at 11:21

Neil Knight · Accepted Answer · 2014-03-19 11:21:14Z

3

You are missing an AND before sectionname. Corrected SQL below:

cmd.CommandText = " UPDATE [Solve_Student_question] 
                   SET Answ= '" + ans + "' ,
                       Start_time='" + sTime + "',
                       End_time='" + eTime + "' 
                 WHERE Qno='" + Qno + "' AND 
                       User_id='" + userid + "' AND
                       Exame_id='" + examid + "' AND sectionname='" + sectionname + "'";

answered Mar 19, 2014 at 11:21

Neil Knight

48.8k26 gold badges136 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mustaphahawi · Accepted Answer · 2014-03-19 11:19:44Z

0

cmd.CommandText = " Update [Solve_Student_question] set Answ= '" + ans + "' ,Start_time='" + sTime + "',End_time='" + eTime + "' where Qno='" + Qno + "' AND User_id='" + userid + "' and Exame_id='" + examid + "'and sectionname='" + sectionname + "'";

answered Mar 19, 2014 at 11:19

mustaphahawi

2971 silver badge8 bronze badges

Collectives™ on Stack Overflow

Why Update query not working?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related