Insert new record into MS Access Database through .net Window Form

See more:

.NET2.0

.NET

Hello

I am new in .net, and working on a project in which i am trying to insert a new record in MS Access database from windows form. And for that i wrote the following code. This code show a message that New Record added successfuly. But no new record is added in databse. Plz help me, what are the required changes in following code.
Thank you.

<pre>OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database1.mdb");
con.Open();
string str = "insert into FormA_Table(Name1,Fathers_Name,Husband_Name,DOB,Address_Of_Res,Address_of_practice,Medical_qualification,Degree_Qualification,year_of_passing,Name_of_institute,Reg_no,Reason_Name_Date_Rule,Revised_date,ReEntry_date,Additional_qualification,Additional_Qualification1,Additional_Qualif_Date,emp_info,Address_of_Employer,Remarks,Sign_Registrar,Reg_date,Intern_From,Intern_To,Revision_Varified)values('" + txtName.Text + "',@fname,@hname,@dob,@res_add,@p_add,@m_qualif,'" + txtQualification.Text + "',@year,'" + txtInstitute.Text + "','" + txtRegistration.Text + "','" + txtReason.Text + "',@revdate,@reentrydate,@add_qualif,'" + txtAddQualification.Text + "',@q_date,@e_type,@e_add,'" + txtRemarks.Text + "',@na,@reg_date,@i_from,@i_to,@rev)";

OleDbCommand cmdInsert = new OleDbCommand(str, con);
cmdInsert.Parameters.Add("@fname", OleDbType.VarChar);
cmdInsert.Parameters["@fname"].Value = FName;
cmdInsert.Parameters.Add("@hname", OleDbType.VarChar);
cmdInsert.Parameters["@hname"].Value = HName;

cmdInsert.Parameters.Add("@dob", OleDbType.VarChar);
cmdInsert.Parameters["@dob"].Value = DOB1;

cmdInsert.Parameters.Add("@res_add", OleDbType.VarChar);
cmdInsert.Parameters["@res_add"].Value = Res_Address; ;

cmdInsert.Parameters.Add("@p_add", OleDbType.VarChar);
cmdInsert.Parameters["@p_add"].Value = Pra_Address;
cmdInsert.Parameters.Add("@m_qualif", OleDbType.VarChar);
cmdInsert.Parameters["@m_qualif"].Value = med_qualif;
cmdInsert.Parameters.Add("@year", OleDbType.Integer);
cmdInsert.Parameters["@year"].Value = year;
cmdInsert.Parameters.Add("@rev_date", OleDbType.VarChar);
cmdInsert.Parameters["@rev_date"].Value = RevisedDate1;
cmdInsert.Parameters.Add("@reentrydate", OleDbType.VarChar);
cmdInsert.Parameters["@reentrydate"].Value = reEntry1;
cmdInsert.Parameters.Add("@add_qualif", OleDbType.VarChar);
cmdInsert.Parameters["@add_qualif"].Value = add_qualType;
cmdInsert.Parameters.Add("@q_date", OleDbType.VarChar);
cmdInsert.Parameters["@q_date"].Value = qualifDate1; ;
cmdInsert.Parameters.Add("@e_type", OleDbType.VarChar);
cmdInsert.Parameters["@e_type"].Value = emp_type;
cmdInsert.Parameters.Add("@e_add", OleDbType.VarChar);
cmdInsert.Parameters["@e_add"].Value = Emp_add;
cmdInsert.Parameters.Add("@na", OleDbType.VarChar);
cmdInsert.Parameters["@na"].Value = NA;
cmdInsert.Parameters.Add("@reg_date", OleDbType.VarChar);
cmdInsert.Parameters["@reg_date"].Value = Reg_Date1;
cmdInsert.Parameters.Add("@i_from", OleDbType.VarChar);
cmdInsert.Parameters["@i_from"].Value = InternFrom;
cmdInsert.Parameters.Add("@i_to", OleDbType.VarChar);
cmdInsert.Parameters["@i_to"].Value = InternTo;
cmdInsert.Parameters.Add("@rev", OleDbType.VarChar);
cmdInsert.Parameters["@rev"].Value = revised1;
int i= cmdInsert.ExecuteNonQuery();
if (i &gt; 0)
MessageBox.Show("New Record Added successfuly");
else
MessageBox.Show("Fail to save new record");
con.Close();
cmdInsert.Dispose();</pre>