المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : Incorrect syntax near the keyword 'Transaction'



C# Programming
07-24-2009, 08:12 AM
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;
}
}