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);
}
}
