private void AddTemplateItemToInspection()
      {
      try
        {
        //verify there is a building
        _InspectionID = Convert.ToInt32(this.inspectionIDTextBox.Text);

        if (string.IsNullOrEmpty(comboBoxBuilding.SelectedValue.ToString()))
          {
          MessageBox.Show("You must select a building for this inspection item.");
          return;
          }
        string sql;

        //see of unit id is null and set sql string accordingly
        if (string.IsNullOrEmpty(comboBoxUnit.SelectedValue.ToString()))
          {
          sql = "INSERT INTO tblInspectionChecklist(InspectionID, BuildingID, Category, InspectableItem, ItemWeight, ObservableDeficiency, Criticality) " +
                               "Values(@_InspectionID, @_BuildingID, @_Category, @_InspItem, @_ItemWeight, @_ObservDef, @_Criticality)";
          }
        else
          {
          sql = "INSERT INTO tblInspectionChecklist(InspectionID, BuildingID, UnitID, Category, InspectableItem, ItemWeight, ObservableDeficiency, Criticality) " +
                               "Values(@_InspectionID, @_BuildingID, @_UnitID, @_Category, @_InspItem, @_ItemWeight, @_ObservDef, @_Criticality)";
          }

        //set up oledb actions
        string s = ConfigurationManager.AppSettings["connString"];
        OleDbConnection c = new OleDbConnection(s);
        OleDbCommand command = new OleDbCommand(sql, c);
        command.Parameters.AddWithValue(@"_InspectionID", _InspectionID);
        if (comboBoxUnit.SelectedText != null)
          {
          command.Parameters.AddWithValue(@"_UnitID", Convert.ToInt32(comboBoxUnit.SelectedValue));
          }
        command.Parameters.AddWithValue(@"_BuildingID", Convert.ToInt32(comboBoxBuilding.SelectedValue));
        command.Parameters.AddWithValue(@"_InspItem", _InspItem);
        command.Parameters.AddWithValue(@"_ObservDef", _ObservDef);
        command.Parameters.AddWithValue(@"_Category", this.comboBoxInspectionArea.SelectedValue);
        command.Parameters.AddWithValue(@"_Criticality", _Criticality);
        command.Parameters.AddWithValue(@"_ItemWeight", _ItemWeight);
        c.Open();
        command.ExecuteNonQuery();
        c.Close();

        }
      catch (OleDbException ex)
        {
        MessageBox.Show(ex.Message + " " + ex.Source.ToString());
        }
      }