// SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-89LF16D;Initial Catalog=Hospital;Integrated Security=True"); private void ultraBtnSave_Click(object sender, EventArgs e) { objHospitalDB = new HospitalDB(); Bed objBed = new Bed(objHospitalDB); BedRow objBedRow = new BedRow(); objBedRow.BedName = ultraTextBedName.Text; objBedRow.BedType = ultraComboBed.Text; objBedRow.RatePerDay = Convert.ToInt32(ultraTextRatePerDay.Text); if (strFormMode == "NEW") { if (MessageBox.Show("Are you sure you want to save", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { objBed.Insert(objBedRow); this.Hide(); } } /*SqlCommand query = objHospitalDB.CreateCommand("insert into Bed Values('" + ultraTextBedName.Text + "','" + ultraTextRatePerDay.Text + "','" + ultraComboBed.Text + "')", false); * // SqlDataAdapter sda = new SqlDataAdapter(query, con); * int p = query.ExecuteNonQuery(); * MessageBox.Show(p + "Value is registerd"); * this.Hide();*/ else { objBedRow.Bed_ID = Convert.ToInt32(this.id); objBed.Update(objBedRow); } }