Please solve the error Incorrect syntax near Add

Question

0.00/5 (No votes)

See more:

C#

CheckBox chk = (CheckBox)GridView1.Rows[i].Cells[2].FindControl("CheckBox1");
                if (chk != null)
                {
                    if (chk.Checked)
                    {
                        if (!Page.IsPostBack)
                        {
                            string strID = GridView1.Rows[i].Cells[0].Text;
                            string Pages = GridView1.Rows[i].Cells[1].Text;
                            string status = "Y";

                            SqlCommand cmd = new SqlCommand();
                            cmd = new SqlCommand("Update Role1  Set Add ='" + status + "' where ID= '" + strID + "'  and Pages= '" + Pages + "'", con);
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                            GridView1.DataBind();
                        }
                    }
                    else
                    {



                        string strID = GridView1.Rows[i].Cells[0].Text;
                        string Pages = GridView1.Rows[i].Cells[1].Text;
                        string status = "N";
                        chk.Checked = false;

                        SqlCommand cmd = new SqlCommand();
                        //cmd = new SqlCommand("insert into Role1(Checkin_Add) values(" + status + " where ID= '" + strID + "' and Role_Name='" + strName + "')", con);
                        cmd = new SqlCommand("Update Role1  Set Add ='" + status + "' where ID= '" + strID + "'  and Pages= '" + Pages + "'", con);
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                        GridView1.DataBind();
                    }

                }

Posted 13-Mar-14 23:20pm

Member 10578683

Updated 13-Mar-14 23:47pm

phil.o

v2

Add a Solution

3 solutions

Solution 2

Maybe your column name "Add" is incorrect and should be "Checkin_Add" like in the commented line!?

Could you provide the SQL tables definitions details?

Posted 13-Mar-14 23:25pm

Raul Iloc

Updated 13-Mar-14 23:26pm

v2

Comments

Member 10578683 14-Mar-14 5:34am

i have taken the column name Add in Role1 database

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ErBhati · Accepted Answer · 2014-03-13T23:50:00

Solution 3

C#

cmd = new SqlCommand("Update Role1 Set [Add] =" + status + "' where ID=" + strID + " and Pages= '" + Pages + "'", con);

if Add,Id and Page are int type then Remove (' ') and if these are string type not remove

Posted 13-Mar-14 23:50pm

ErBhati

v3

Aravindba · Accepted Answer · 2014-03-13T23:24:00

Solution 1

hai

pls specify which line u get error ? bcz u have Add word in If part and also in Else part.pls check strID and Page field data type in ur database,is it nvarchar or integer,bcz u mention as strId and pages as string,what u get in this 2 fields ? any numbers or string ?

If it is integer in ur database then change as follows

C#

cmd = new SqlCommand("Update Role1 Set Add ='" + status + "' where ID= " + strID + " and Pages= " + Pages + "", con);

or try like this

C#

cmd = new SqlCommand("Update Role1 Set [Add] ='" + status + "' where ID= '" + strID + "' and Pages= '" + Pages + "'", con);

Give square bracket for [Add] column name,bcz Add,New,Date ect are predefined word in visual studio,u cant use same as a variable.

Try to change "Add" field name to any other name or give square bracket,best u rename Add to added or adding like this

Posted 13-Mar-14 23:24pm

Aravindba

Updated 13-Mar-14 23:37pm

v5

Comments

Member 10578683 14-Mar-14 5:32am

In else part i m getting error near cmd.ExecuteNonQuery

Member 10578683 14-Mar-14 5:33am

Incorrect syntax near the keyword 'Add'.

Aravindba 14-Mar-14 5:36am

Try to give like this cmd = new SqlCommand("Update Role1 Set [Add] ='" + status + "' where ID= '" + strID + "' and Pages= '" + Pages + "'", con);

see my solution updated

Member 10578683 14-Mar-14 5:40am

ya i did like this
it is executing

Member 10578683 14-Mar-14 5:40am

It is now executing. but the if part is not executing

Aravindba 14-Mar-14 6:45am

hello in if part also u need to change Add to [Add].
Give square bracket for [Add] field name,
Bcz Add,New,Date,Delete,Set,Get,Name etc are predefined word in visual studio,u cant use same as a variable.
in table also u need to replace column form Add to [Add],in best practice try to avoid visual studio predefined variable as ur code variable