Incorrect syntax near the keyword 'Transaction'

haleemasher

i want to insert data into the sql database when i click on submit button it show error that incorrect syntax near the keyword 'Transaction'. i cann't find this error plz help

protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{

        ErrorMessage.Text = "";
        cnx.Open();
        SqlCommand insertCmd = new SqlCommand("INSERT INTO TransactionType(Transaction,Description,Category,Active)

VALUES(@Transaction,@Description,@Category,@Active)", cnx);
insertCmd.Parameters.Add("@Transaction", SqlDbType.NVarChar, 50);
insertCmd.Parameters["@Transaction"].Value = txtProgram.Text;

        insertCmd.Parameters.Add("@Description", SqlDbType.Text );
        insertCmd.Parameters\["@Description"\].Value = txtdescrip.Text;

        insertCmd.Parameters.Add("@Category", SqlDbType.NVarChar ,50);
        insertCmd.Parameters\["@Category"\].Value = DdlCategory.Text;

        insertCmd.Parameters.Add("@Active", SqlDbType.NChar ,10);
        insertCmd.Parameters\["@Active"\].Value = DdlActive.Text;

        insertCmd.ExecuteNonQuery();
        ErrorMessage.Text = "Successful";
        cnx.Close();
    }
    catch (Exception ex)
    { 
        ErrorMessage.Text = ex.Message;
    }
}

Curtis Schlak

In Microsoft SQL Server (and probably any other RDBMS that supports transactions), TRANSACTION is a reserved keyword. Change your SQL to read

INSERT INTO TransactionType([Transaction],Description,Category,Active)
VALUES(@Transaction,@Description,@Category,@Active)

The square brackets indicate a name rather than a keyword.

"we must lose precision to make significant statements about complex systems." -deKorvin on uncertainty

Mike Ellison

The error is telling you that you have a problem with your SQL being sent to the database, not with your C# code. Transaction is a reserved word. Try surrounding it with square brackets [Transaction]

mishainthecloud.blogspot.com

haleemasher

THANK U VERY MUCH ITS WORKS