public void AddOrder() { Order ord = new Order(); ord.Description = textBox1.Text; ord.Product_id = Int32.Parse(comboBox1.Text); ord.Quantity_box = Int32.Parse(textBox2.Text); ord.Weight = Int32.Parse(textBox3.Text); ord.PalletAllocation = int.Parse(textBox4.Text); ord.Customer_id = int.Parse(comboBox2.Text); ord.Order_date = this.dateTimePicker1.Value; ord.Collection_date = this.dateTimePicker2.Value; ord.Price = double.Parse(textBox5.Text); ord.Status = textBox6.Text; ord.Remark = textBox7.Text; InsertSQL ordHnd = new InsertSQL(); int addrecord = ordHnd.addNewOrder(ord); MessageBox.Show(addrecord + "Your record is added"); this.Close(); }