Add, Remove, and Edit values from SQL database

[EDN Admin]

Good evening my fellow programmers,
Error code "Column name or number of supplied values does not match table definition" can you guys give me a hand please and thanks? here is what i have....
<div style="color:Black;background-color:White; <pre>
<span style="color:Blue; private <span style="color:Blue; void btnConfirmAddition_Click(<span style="color:Blue; object sender, EventArgs e)
{
<span style="color:Blue; this.panAddAsset.Visible = <span style="color:Blue; false;
MessageBox.Show(<span style="color:#A31515; "Confirm Addition", <span style="color:#A31515; "Agent Aid Advisor", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

SqlConnection cs = <span style="color:Blue; new SqlConnection(<span style="color:#A31515; @"Data Source=MY DATASOURCE;Integrated Security=True");
SqlDataAdapter da = <span style="color:Blue; new SqlDataAdapter();
<span style="color:Green; //da.InsertCommand = new SqlCommand("INSERT INTO dbo.item VALUES(@EID, @Name, @Model, @Serial, @Country, @Region, @IMEI)", cs);
da.InsertCommand = <span style="color:Blue; new SqlCommand(<span style="color:#A31515; "INSERT INTO dbo.item VALUES(@Vendor_ID, @Service_ID, @EID, @Serial, @Model, @IMEI, @Name, @Country, @Region)", cs);
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Vendor_ID", SqlDbType.Int).Value = Convert.ToInt32(cbCarrierAdd.Text);
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Service_ID", SqlDbType.Int).Value = Convert.ToInt32(cbDeviceAdd.Text);
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@EID", SqlDbType.VarChar).Value = tbEIDAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Serial", SqlDbType.VarChar).Value = maskedTBNumberAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Model", SqlDbType.NVarChar).Value = cbModelAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@IMEI", SqlDbType.VarChar).Value = mtbIMEIAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Name", SqlDbType.NVarChar).Value = tbDisplayNameAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Country", SqlDbType.VarChar).Value = cbCountryAdd.Text;
da.InsertCommand.Parameters.Add(<span style="color:#A31515; "@Region", SqlDbType.VarChar).Value = cbRegionAdd.Text;
<span style="color:Green; //add the number thing for the vendor
<span style="color:Green; //da.InsertCommand.Parameters.Add("@SBG", SqlDbType.VarChar).Value = tbEIDAdd.Text;//ADD SBG TB
<span style="color:Green; //da.InsertCommand.Parameters.Add("@SBU", SqlDbType.VarChar).Value = tbEIDAdd.Text;//ADD SBU
cs.Open();
da.InsertCommand.ExecuteNonQuery();
cs.Close();
cs.Dispose();

<span style="color:Blue; this.btnAddAsset.Visible = <span style="color:Blue; true;
}
[/code]
Any ideas guys?
Please help
<hr class="sig Loving life since 1981 Preston Lambeth

View the full article