3
Hi friend
Please tell me why this error is occured
ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 22.
Cod
Dim InsertString As String = "INSERT INTO TableHR1 VALUES(@No,@name_of_candidate,@Address,@Date_of_bi rth,@PhoneNo,@Email,@Design_Eng,@CAE_Eng,@Mkt,@Acc ounting,@It,@Admin,@Experience,@Industry,@Current_ CTC,@InHand,@ExpectedCTC,@Exp_Inhand,@Joining_Peri od,@Iziel_Result,@Iziel_Remark,@Candidate_Remark) "
Dim cmd As OdbcCommand = New OdbcCommand(InsertString, con)
cmd.Parameters.Add(New OdbcParameter("@No", notxt.Text))
cmd.Parameters.Add(New OdbcParameter("@name_of_candidate", nametxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Address", Addresstxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Date_of_birth", DateOfBirthtxt.Text))
cmd.Parameters.Add(New OdbcParameter("@PhoneNo", Phonetxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Design_Eng", TextBox2.Text))
cmd.Parameters.Add(New OdbcParameter("@CAE_Eng", TextBox3.Text))
cmd.Parameters.Add(New OdbcParameter("@Mkt", TextBox7.Text))
cmd.Parameters.Add(New OdbcParameter("@Accounting", TextBox4.Text))
cmd.Parameters.Add(New OdbcParameter("@It", TextBox8.Text))
cmd.Parameters.Add(New OdbcParameter("@Admin", TextBox5.Text))
cmd.Parameters.Add(New OdbcParameter("@Experience", TextBox1.Text))
cmd.Parameters.Add(New OdbcParameter("@Industry", TextBox6.Text))
cmd.Parameters.Add(New OdbcParameter("@Current_CTC", CurrentCTCtxt.Text))
cmd.Parameters.Add(New OdbcParameter("@InHand", Inhandtxt.Text))
cmd.Parameters.Add(New OdbcParameter("@ExpectedCTC", ExpectedCTCtxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Exp_Inhand", Expectedinhand.Text))
cmd.Parameters.Add(New OdbcParameter("@Joining_Period", joiningtxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Iziel_Result", iZielResultktxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Iziel_Remark", IzielRemarktxt.Text))
cmd.Parameters.Add(New OdbcParameter("@Candidate_Remark", CandidateResulttxt.Text))
con.Open()
cmd.ExecuteNonQuery()
