C# SQL Server CE error at parsing the query

Question

I can't seem to find my error at my code. I copy-pasted it with another one of my codes and just change the table and column names.

It states the error at : "int result = cma.ExecuteNonQuery();"

public bool SaveCheckAmount(string id, int amount, string number, string bank)
{
  conn.Open();

  SqlCeCommand cma = new SqlCeCommand("INSERT INTO Check (transactionID,Amount,CheckNumber,Bank)VALUES(@id,@amount,@number,@bank)",conn);
  cma.Parameters.Add("@id",id);
  cma.Parameters.Add("@amount",amount);
  cma.Parameters.Add("@number",number);
  cma.Parameters.Add("@bank",bank);

  int result = cma.ExecuteNonQuery();

  if(result > 0)
  {
    conn.Close();
    return true;
  }
  else
  {
    conn.Close();
    return false;
  }
}

is the transaction id column an auto generated column? if so then you shouldnt set it in the insert statement — Steven Wood
– Steven Wood, Commented Sep 18, 2013 at 12:56
Soner- There was an error parsing the query. [ Token line number = 1,Token line offset = 13,Token in error = Check ] — Vnz Dichoso
– Vnz Dichoso, Commented Sep 18, 2013 at 12:59

3Dave · Accepted Answer · 2013-09-18 13:03:08Z

3

Try changing this to

SqlCeCommand cma = new SqlCeCommand("INSERT INTO [Check] (transactionID,Amount,CheckNumber,Bank) VALUES (@id,@amount,@number,@bank)",conn);

Check is a reserved word in T-SQL.

See this page on MSDN for a complete list.

answered Sep 18, 2013 at 13:03

3Dave

29.2k18 gold badges91 silver badges155 bronze badges

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

1 Comment

3Dave Over a year ago

It escapes the word, telling SQL that it should be interpreted as an identifier rather than a reserved word. This is also used when referring to entities that, for example, have spaces in the name.

Colm Prunty · Accepted Answer · 2013-09-18 13:03:43Z

2

Check is a reserved SQL keyword, try this:

INSERT INTO [Check]

answered Sep 18, 2013 at 13:03

Colm Prunty

1,6401 gold badge14 silver badges30 bronze badges

Collectives™ on Stack Overflow

C# SQL Server CE error at parsing the query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related