column or table value does not match the table definition

I design and code.

when i insert the values in run time it shows the column or table value does not match the table defintion.

Code

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection("Server=(local);initial catalog=Rental;Trusted_Connection=True");
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into mis values('" + DropDownList1.SelectedItem.Text + "',' " + DropDownList2.SelectedItem.Text + "',' " + DropDownList3.SelectedItem.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "', " + DropDownList4.SelectedItem.Text + "," + TextBox3.Text + "," + TextBox4.Text + "," + TextBox5.Text + "," + TextBox6.Text + "," + TextBox7.Text + "," + TextBox8.Text + "," + TextBox9.Text + "," + TextBox10.Text + ",' " + TextBox11.Text + "',' " + TextBox12.Text + "',' " + DropDownList5.SelectedItem.Text + "')", con);
        cmd.ExecuteNonQuery();
        con.Close();
        Response.Write("Record Inserted Successfully");
    }
}

I send the code and send the design in to attach file.

please solve my problem.

Regards,
Narasiman P

1 Reply

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

Vulpes14y ago
The usual problem with stuff like this is that you're either:

1. Placing single quotes around columns that don't need them (e.g. numeric types); or

2. Failing to place single quotes around columns that do need them (e.g. string or date types).

So, I'd check that first.

The only other possible problem I can think of is that the number of values you're inserting is not the same as the number of fields in the 'mis' table which, of course, it needs to be.