What is the error in this SQL update stament

Question

I have the method that do update to data base table but when I invoke it I have an exception "Incorrect syntax near '('."

Here is the method

 internal Boolean update(int customerID,int followingID, string fullName, string idNumber, string address, string tel, string mobile1, string mobile2, string email, string customerComment, DateTime timeStamp)
     {
         string sqlStatment = "update customers set (followingID, fullName,idNumber,address,tel,mobile1,mobile2,email,customerComment,timeStamp) = (@followingID, @fullName,@idNumber,@address,@tel,@mobile1,@mobile2,@email,@customerComment,@timeStamp) where customerID=@customerID";

         SqlConnection con = new SqlConnection();
         con.ConnectionString = connection;
         SqlCommand cmd = new SqlCommand(sqlStatment, con);

         cmd.Parameters.AddWithValue("@customerID", customerID);
         cmd.Parameters.AddWithValue("@followingID", followingID);
         cmd.Parameters.AddWithValue("@fullName", fullName);
         cmd.Parameters.AddWithValue("@idNumber", idNumber);
         cmd.Parameters.AddWithValue("@address", address);
         cmd.Parameters.AddWithValue("@tel", tel);
         cmd.Parameters.AddWithValue("@mobile1", mobile1);
         cmd.Parameters.AddWithValue("@mobile2", mobile2);
         cmd.Parameters.AddWithValue("@email", email);
         cmd.Parameters.AddWithValue("@customerComment", customerComment);
         cmd.Parameters.AddWithValue("@timeStamp", timeStamp);


         bool success = false;
         try
         {

             con.Open();
             cmd.ExecuteNonQuery();
             success = true;

         }
         catch (Exception ex)
         {

             success = false;
             //throw ex;
         }
         finally
         {
             con.Close();
         }
         return success;
     }

and here is the database table columns

Customers table

UPDATE sql query syntax is wrong... – Tamil Selvan C Sep 26 '13 at 05:23 — Tamil Selvan C, Sep 26 '13 at 05:23

score 5 · Answer 1 · answered Sep 26 '13 at 05:23

Your Syntax error is incorrect.Please refer the link for Update Query Syntax

update customers 
set 
followingID= @followingID, 
fullName=@fullName,
idNumber=@idNumber,
address=@address,
tel=@tel,
mobile1=@mobile1,
mobile2=@mobile2,
email=@email,
customerComment=@customerComment,
timeStamp=@timeStamp
where customerID=@customerID

Amit · Answer 2 · 2013-09-26T07:52:11.743

5

Your sql update statement is wrong. For more about update statement see

     string sqlStatment = "update customers set followingID=@followingID,
          fullName=@fullName,idNumber=@idNumber,address=@address,tel=@tel,
          mobile1=@mobile1,mobile2=@mobile2,email=@email,
          customerComment=@customerComment,timeStamp=@timeStamp
        where customerID=@customerID";

edited Sep 26 '13 at 07:52

answered Sep 26 '13 at 05:24

Amit

15,217
8
46
68

score 2 · Answer 3 · answered Sep 26 '13 at 05:25

2

Please see the Update statement syntax:

http://www.w3schools.com/sql/sql_update.asp

you cannot bulk update values in the table

answered Sep 26 '13 at 05:25

Manikandan Sigamani

1,964
1
15
28

score 2 · Accepted Answer · answered Sep 26 '13 at 05:27

UPDATE syntax is wrong..

Try

string sqlStatment = "UPDATE customers SET followingID= @followingID, fullName=@fullName, idNumber=@idNumber,address=@address,tel=@tel,mobile1=@mobile1,mobile2=@mobile2,email=@email,customerComment=@customerComment,timeStamp=@timeStamp WHERE customerID=@customerID"

score 1 · Answer 5 · edited Sep 26 '13 at 07:49

1

Never seen an update statement like that - normally it'd be set followingid = @followingid, fullname = @fullname etc, etc

edited Sep 26 '13 at 07:49

Satpal

132,252
13
159
168

answered Sep 26 '13 at 05:25

Andrew

2,315
3
27
42

score 0 · Answer 6 · answered Sep 26 '13 at 06:30

There is syntax error, update statement is used like this

update customers set followingID=@followingID,
fullName=@fullName,
idNumber=@idNumber,
address=@address,
tel=@tel,
mobile1=@mobile1,
mobile2=@mobile2,
email=@email,
customerComment=@customerComment,
timeStamp=@timeStamp
where customerID=@customerID

What is the error in this SQL update stament

6 Answers6