private void button42_Click(object sender, EventArgs e) { DataTable dt = controllerObj.GetOID(); int OID = Int16.Parse(dt.Rows[0]["OrderID"].ToString()) + 1; int n = controllerObj.AddOrder(2, Int16.Parse(textBox4.Text), Int16.Parse(textBox2.Text), double.Parse(textBox1.Text), Int16.Parse(textBox5.Text)); if (n == 0) { MessageBox.Show("Insertion Failed"); } else { MessageBox.Show("Insertion succeeded"); for (int i = 0; i < listBox1.Items.Count; i++) { DataTable dt1 = controllerObj.GetItemIDbyName(listBox1.GetItemText(listBox1.Items[i])); string temp = dt1.Rows[0]["ID"].ToString(); controllerObj.AddOrder_Item(Convert.ToString(OID), temp, "1", textBox5.Text); } } }