private void getDesc() { if (m_oAdo.m_OleDbDataReader.IsClosed == false) { return; } m_oAdo.m_strSQL = Queries.GenericSelectSQL(m_oQueries.m_oReference.m_strRefHarvestMethodTable, "description", "TRIM(method)='" + cmbMethod.Text.Trim() + "' AND steep_yn = 'N'"); this.txtDesc.Text = m_oAdo.getSingleStringValueFromSQLQuery(m_oAdo.m_OleDbConnection, m_oAdo.m_strSQL, "temp"); }
public void LoadValues() { string strNotes = ""; FIA_Biosum_Manager.ado_data_access oAdo = new ado_data_access(); string strScenarioDBDir = frmMain.g_oFrmMain.frmProject.uc_project1.txtRootDirectory.Text.Trim() + "\\" + ScenarioType + "\\db"; string strScenarioFile = "scenario_" + ScenarioType + "_rule_definitions.mdb"; StringBuilder strScenarioFullPath = new StringBuilder(strScenarioDBDir); strScenarioFullPath.Append("\\"); strScenarioFullPath.Append(strScenarioFile); string strScenarioConn = oAdo.getMDBConnString(strScenarioFullPath.ToString(), "admin", ""); oAdo.OpenConnection(strScenarioConn); if (ScenarioType.Trim().ToUpper() == "OPTIMIZER") { oAdo.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceOptimizerScenarioForm.uc_scenario1.strScenarioId.Trim() + "'"; } else { oAdo.m_strSQL = "SELECT notes FROM scenario WHERE TRIM(scenario_id)='" + this.ReferenceProcessorScenarioForm.uc_scenario1.strScenarioId.Trim() + "'"; } strNotes = oAdo.getSingleStringValueFromSQLQuery(oAdo.m_OleDbConnection, oAdo.m_strSQL, "scenario"); oAdo.m_OleDbConnection.Close(); while (oAdo.m_OleDbConnection.State != System.Data.ConnectionState.Closed) { oAdo.m_OleDbConnection.Close(); System.Threading.Thread.Sleep(1000); } oAdo = null; this.txtNotes.Text = strNotes; }