Column name of supplied values does not match table definition

emma oj

i get this error when a checkbox is checked

Server Error in '/WebSite6' Application.
Column name or number of supplied values does not match table definition.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Column name or number of supplied values does not match table definition.

Source Error:

Line 63:                         cmd.Parameters.AddWithValue("@accepted_clylinder", "{'" + number.Trim() + "'}");
Line 64:                         con.Open();
Line 65:                         cmd.ExecuteNonQuery();
Line 66:                         con.Close();
Line 67:                     }

Please find attached My Code

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravinder Sharma5y ago
Hey,
Try to specify the column name you want to insert like:
Must check if there are more column than that

using (SqlCommand cmd = new SqlCommand("INSERT INTO Tracking1(pretext, accepted_clylinder) VALUES(@preText, @accepted_clylinder)", con))
{
cmd.Parameters.AddWithValue("@preText", preText);
cmd.Parameters.AddWithValue("@accepted_clylinder", "{'" + number.Trim() + "'}");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
Sachin Singh5y ago
1. using (SqlCommand cmd = new SqlCommand("INSERT INTO Tracking1 VALUES(@preText, @accepted_clylinder)", con))
2. {
3. cmd.Parameters.AddWithValue("@preText", preText);
4. cmd.Parameters.AddWithValue("@accepted_clylinder", "{'" + number.Trim() + "'}");
5. con.Open();
6. cmd.ExecuteNonQuery();
7. con.Close();
8. }
There are 3 possibilities,
1. Table Tracking1 has more than 2 columns but you are supplying just 2 values.
2. You don't have an Identity column, so you need to pass the id as well, check your table definition, and make sure you have marked the primary key column as identity(Auto incremented).
3. Number.Trim() column, is varchar, so directly pass it.
1. using (SqlCommand cmd = new SqlCommand("INSERT INTO Tracking1 VALUES(@preText, @accepted_clylinder)", con))
2. {
3. cmd.Parameters.AddWithValue("@preText", preText);
4. cmd.Parameters.AddWithValue("@accepted_clylinder", number.Trim());
5. con.Open();
6. cmd.ExecuteNonQuery();
7. con.Close();
8. }