private void addPesticideJob() { PesticideJob pj = new PesticideJob(); pj.Description = textBox1.Text; string idStr = cbPesticide.Text.Split('.')[0]; pj.Pesticide_id = int.Parse(idStr); pj.Quantity_kg = int.Parse(textBox3.Text); string idStr1 = cbSoj.Text.Split('.')[0]; pj.SowingJob_id = int.Parse(idStr1); string idStr2 = cbFarm.Text.Split('.')[0]; pj.Farm_id = int.Parse(idStr2); string idStr3 = cbVehicle.Text.Split('.')[0]; pj.Vehicle_id = int.Parse(idStr3); string idStr4 = cbCrop.Text.Split('.')[0]; pj.Crop_id = int.Parse(idStr4); string idStr5 = cbEmployee.Text.Split('.')[0]; pj.Employee_id = int.Parse(idStr5); pj.Date_start = Convert.ToDateTime(dtpStart.Text); pj.Date_end = Convert.ToDateTime(dtpEnd.Text); InsertSQL add = new InsertSQL(); int addrecord = add.addNewPesticideJob(pj); MessageBox.Show("Success!!"); this.Close(); }