Hi there..
Try this.
private void button1_Click(object sender, EventArgs e)
{
if (validationcontrol())
{
MessageBox.Show(cmbjobcode.SelectedValue.ToString());
OleDbConnection oleDbConnection1 = new System.Data.OleDb.OleDbConnection(connString);
oleDbConnection1.Open();
OleDbCommand oleDbCommand1 = new System.Data.OleDb.OleDbCommand("INSERT INTO quotationmastertable (quotationcode ,jobcode , jobpk , sillabordercharges , battabordercharges , driverpayment , rent , extra , total , discount , remark ,amount ) Values(@quotationcode ,@jobcode , @jobpk , @sillabordercharges , @battabordercharges , @driverpayment , @rent , @extra , @total , @discount , @remark ,@amount ) ", oleDbConnection1);
oleDbCommand1.Parameters.Add("@quotationcode", txtquotationno.Text);
oleDbCommand1.Parameters.Add("@jobcode", cmbjobcode.Text);
oleDbCommand1.Parameters.Add("@jobpk", cmbjobcode.SelectedValue);
oleDbCommand1.Parameters.Add("@sillabordercharges", int.Parse(txtsilabordercharges.Text));
oleDbCommand1.Parameters.Add("@battabordercharges", int.Parse(txtbattacharges.Text));
oleDbCommand1.Parameters.Add("@driverpayment", int.Parse(txtdriverpayment.Text));
oleDbCommand1.Parameters.Add("@rent", int.Parse(txtrent.Text));
oleDbCommand1.Parameters.Add("@extra", int.Parse(txtextra.Text));
oleDbCommand1.Parameters.Add("@total", int.Parse(txttotal.Text));
oleDbCommand1.Parameters.Add("@discount", int.Parse(txtdiscount.Text));
oleDbCommand1.Parameters.Add("@remark", txtremark.Text);
oleDbCommand1.Parameters.Add("@amount", int.Parse(txtamount.Text));
oleDbCommand1.CommandType = CommandType.Text;
oleDbCommand1.ExecuteNonQuery();
oleDbConnection1.Close();
MessageBox.Show(txtquotationno.Text);
}
}