public void Insert()
{
try
{
string qurey = "INSERT INTO tab1(prsnli,nam,family,amozeshkah,dorh,tedad,onwan1,marge1,data1,onwan2,marge2,data2,onwan3,marge3,data3,onwan4,marge4,data,onwan5,marge5,data5) values('" + prsnli.Text + "','" + nem.Text + "','" + family.Text + "','" + amozeshkah.Text + "','" + dorh.Text + "','" + cbOnvan1.Text + "','" + cbMarja1.Text + "','" + dateTimePicker1.Text + "', '" + cbOnvan2.Text + "','" + cbMarja2.Text + "','" + dateTimePicker2.Text + "''" + cbOnvan3.Text + "','" + cbMarja3.Text + "','" + dateTimePicker3.Text + "''" + cbOnvan4.Text + "','" + cbMarja4.Text + "','" + dateTimePicker4.Text + "''" + cbOnvan4.Text + "','" + cbMarja5.Text + "','" + dateTimePicker5.Text + "')";
OleDbConnection con = new OleDbConnection(ConnectionString);
OleDbCommand com = new OleDbCommand(qurey, this.connect);
com.Parameters.AddWithValue("@prsnli", this.prsnli.Text);
com.Parameters.AddWithValue("@nem ", this.nem.Text);
com.Parameters.AddWithValue("@family", this.family.Text);
com.Parameters.AddWithValue("@amozeshkah", this.amozeshkah.Text);
com.Parameters.AddWithValue("@dorh", this.dorh.Text);
com.Parameters.AddWithValue("@onwan1", this.cbOnvan1.Text);
com.Parameters.AddWithValue("@marge1", this.cbMarja1.Text);
com.Parameters.AddWithValue("@data1", this.dateTimePicker1.Text);
com.Parameters.AddWithValue("@onwan2", this.cbOnvan2.Text);
com.Parameters.AddWithValue("@marge2", this.cbMarja2.Text);
com.Parameters.AddWithValue("@data2", this.dateTimePicker2.Text);
com.Parameters.AddWithValue("@onwan3", this.cbOnvan3.Text);
com.Parameters.AddWithValue("@marge3", this.cbMarja3.Text);
com.Parameters.AddWithValue("@data3", this.dateTimePicker3.Text);
com.Parameters.AddWithValue("@onwan4", this.cbOnvan4.Text);
com.Parameters.AddWithValue("@marge4", this.cbMarja4.Text);
com.Parameters.AddWithValue("@data4", this.dateTimePicker4.Text);
com.Parameters.AddWithValue("@onwan5", this.cbOnvan5.Text);
com.Parameters.AddWithValue("@marge5", this.cbMarja5.Text);
com.Parameters.AddWithValue("@data5", this.dateTimePicker5.Text);
com.Connection.Open();
com.ExecuteNonQuery();
MessageBox.Show("با موفقیت ثبت شد ");
}
catch //ÈÑÇí ãÏíÑíÊ ÎØÇ
{
MessageBox.Show("ok");
}
finally
{
this.connect.Close();
}
}