private void FormImportAnalysisLIS_Load(object sender, EventArgs e) { SqlConnection connection = null; try { connection = DB.OpenConnection(); AllNuclides = DB.GetNuclideNames(connection, null); AnalMethNuclides = DB.GetNuclideNamesForAnalysisMethod(connection, null, mAnalysis.AnalysisMethodId); int sampNum = DB.GetSampleNumber(connection, null, mPreparation.SampleId); string geomName = DB.GetGeometryName(connection, null, mPreparation.PreparationGeometryId); tbFilename.Text = mAnalysis.ImportFile; tbLIMSSampleName.Text = sampNum.ToString(); tbLIMSPrepGeom.Text = geomName; tbLIMSGeomFillHeight.Text = mPreparation.FillHeightMM.ToString(); tbLIMSGeomAmount.Text = mPreparation.Amount.ToString(); tbLIMSGeomQuantity.Text = mPreparation.Quantity.ToString(); LoadLIS(mAnalysis.ImportFile); foreach (AnalysisResult r in mAnalysis.Results) { if (r.DetectionLimit == 0.0) { r.DetectionLimitApproved = false; } } PopulateUI(); } catch (Exception ex) { Common.Log.Error(ex); MessageBox.Show("Error: " + ex.Message); } finally { connection?.Close(); } }