err: column name or number of supplied values does not match

navya b

i was getting an error :Column name or number of supplied values does not match table definition.

Line 23: cmd.ExecuteNonQuery();

-------------------

this is my c# code

protected void Button1_Click(object sender, EventArgs e)
{

string gend = RadioButtonList1.SelectedItem.ToString();
con.Open();

SqlCommand cmd = new SqlCommand("INSERT into OwnerReg VALUES('" + TextBox1.Text + "',
'" + TextBox2.Text + "', '" + TextBox7.Text + "',
'" + gend + "','" + TextBox3.Text + "','" + TextBox4.Text + "',
'" + TextBox5.Text + "','" + TextBox6.Text + "')", con);
cmd.ExecuteNonQuery();

con.Close();

Label16.Text = "Registered Successfully....";

}

--------------------------------------------------------

Data base table: OwnerReg

Username nvarchar(50),Password nvarchar(50),ConfirmPassword nvarchar(50),Gender nvarchar(50),DOB nvarchar(50),

Email nvarchar(MAX),MobileNO nvarchar(50),Address nvarchar(MAX)

plz help me...

5 Replies

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

Shuvojit Halder11y ago
Accepted answer
You may do INSERT into OwnerReg(col1,col2,col3) VALUES('"+your val+"','"+your val+"','"+your val+"');
navya b11y ago
thank you all for ur replies i got it. i misplaced the connection string
Jaipal Reddy11y ago
Please look at once again the values u send through tha textbox are less than column list provided in your query. And it should exacly match the values with column list.

fro example :
txtusaername -> Username
txtpassword -> password check like that.
Jaipal Reddy11y ago
Do insert properly like

Insert tbl_name(col1, col2 , .... last_Col) values(val1, val2 .... last_value)
Upendra Pratap Shahi11y ago
insert intoTable_Name(ID,DNumber,LoginID,OrgNode,OrgLevel,JobTitle,BirthDate,MaritalStatus,Gender,HireDate,SalariedFlag,VacationHours,SickLeaveHours,CurrentFlag,rowguid,ModifiedDate)
values(value1,........................................,yourlast value)

the values should be given in the order in which the column names are specified