private void insertrecord() { try { if (MessageBox.Show("Are you sure you want to save this new District?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { string DivisionID = ""; cn.Open(); cm = new SqlCommand("Select DivisionID from Division where DivisionName like '" + cbodivision.Text + "'", cn); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { DivisionID = dr[0].ToString(); } dr.Close(); cn.Close(); cn.Open(); cm = new SqlCommand("INSERT INTo District(DistrictName,DisctrictNum, DivisionID)VALUEs(@1, @2, @3)", cn); cm.Parameters.AddWithValue("@1", txtdistrictname.Text); cm.Parameters.AddWithValue("@2", cbodistrictnum.Text); cm.Parameters.AddWithValue("@3", DivisionID); cm.ExecuteNonQuery(); MessageBox.Show("Record Has been succesfully save."); cn.Close(); clear(); frmlist.loadrecord(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }