title: mysql exception incorrect integer value : '@column' for column from asp.net web application
body: <p>i am trying to update a table created using mysql database from an ASP.NET Web page. While inserting data into table from web page
   <strong><em>mysqlexception : incorrect integer value :'@Age' for column Age at row 1</em></strong> this exception occurs.</p>
  
  <p>i tried not using single quotes around column name in query but that too not working in that case <strong><em>Age cannot be null exception is occurring</em></strong></p>
  
  <p>here is the code snippet for DML query i am using :</p>
  
  <pre><code>MySqlCommand cmd = new MySqlCommand("Insert into personal(PAN,PName,Age)values('@PAN','@PName','@Age')",con);
              cmd.Parameters.AddWithValue("@PAN",SqlDbType.VarChar).Value= panBox.Text;
              cmd.Parameters.AddWithValue("@PName", SqlDbType.VarChar).Value=nameBox.Text;
              cmd.Parameters.AddWithValue("@Age",MySqlDbType.Int32).Value=Convert.ToInt32(ageBox.Text);
              cmd.ExecuteNonQuery();
              cmd.Dispose();
  </code></pre>
  
  <p>i am a beginner can someone help me with the situation?</p>