Error with an insert query

[Mashi Perera]

Hi
When i'm try to insert data it gives an error saying that Error in INSERT INTO statement.
This is my code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
 
namespace WebApplication2
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        public string vdate;
        public int vaccno;
        public int vamount;
        public int i;
        public decimal vcbalance;
        public decimal balance;
 
 
 
        protected void Page_Load(object sender, EventArgs e)
        {
 
        }
 
        protected void Button2_Click(object sender, EventArgs e)
        {
            //Session.Abandon();
 
            Session.Abandon();
            Response.Redirect("Default.aspx");
 
 
 
        }
 
 
 
        protected void Button1_Click(object sender, EventArgs e)
        {
            vdate = TextBox3.Text;
            vaccno = int.Parse(TextBox1.Text);
            vamount = int.Parse(TextBox2.Text);
 
 
            OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=C:/Samashika/aaa/Database1.mdb");
            try
            {
                con.Open();
            }
            catch (OleDbException) { }
 
 
            //string qry = "INSERT INTO Transaction VALUES (@vdate,@accno,amount)";
            OleDbCommand com = new OleDbCommand("INSERT INTO Transaction VALUES (@vdate,@accno,amount)", con);
           // OleDbCommand com = new OleDbCommand(qry, con);
            com.Parameters.AddWithValue("@vdate", vdate);
            com.Parameters.AddWithValue("@accno", vaccno);
            com.Parameters.AddWithValue("@amount", vamount);
 
            i = com.ExecuteNonQuery();
            if (i > 0)
            {
                Label5.Text = "record addedd";
            }
 
 
 
        }
 
 
 
 
    }
}

[Stewart Ross]

You are inserting three values, two of which are parameterised. The third variable, amount, is not the name of the parameter @amount you have set up, nor does it match the name of the variable vamount which you use to set the parameter.

-Stewart

[Mashi Perera]

Hi
I set the variables as you said.But it didn't work.
Thanks