private void FillGridViewForAxisAndLegendPopups(string PopupMode) { SqlParameter[] _objectSqlParmeters; DataSet datasetDSMDescriptions = null; var CurrentDiagnosis = SHS.BaseLayer.BaseCommonFunctions.GetScreenInfoDataSet(); _objectSqlParmeters = new SqlParameter[1]; _objectSqlParmeters[0] = new SqlParameter("@Subatance", PopupMode); datasetDSMDescriptions = SqlHelper.ExecuteDataset(Connection.ConnectionString, CommandType.StoredProcedure, "csp_SCGetSubstanceUseDiagnosis", _objectSqlParmeters); if (datasetDSMDescriptions != null && datasetDSMDescriptions.Tables.Count > 0) { GridViewAxisI.DataSource = datasetDSMDescriptions; GridViewAxisI.DataBind(); } //GridViewAxisI.DataSource = CurrentDiagnosis.Tables["DocumentDiagnosisCodes"]; //GridViewAxisI.DataBind(); Page.Title = "Diagnosis Code"; }
private void FillGridViewForAxisAndLegendPopups() { SqlParameter[] _objectSqlParmeters; DataSet datasetDSMDescriptions = null; var CurrentDiagnosis = SHS.BaseLayer.BaseCommonFunctions.GetScreenInfoDataSet(); //_objectSqlParmeters = new SqlParameter[1]; // _objectSqlParmeters[0] = new SqlParameter("@ClientId", SHS.BaseLayer.BaseCommonFunctions.ApplicationInfo.Client.ClientId); // datasetDSMDescriptions = SqlHelper.ExecuteDataset(Connection.ConnectionString, CommandType.StoredProcedure, "csp_SCGetPreviousDiagnosisPsychiatricNote", _objectSqlParmeters); // if (datasetDSMDescriptions != null && datasetDSMDescriptions.Tables.Count>0) // { // GridViewAxisI.DataSource = datasetDSMDescriptions; // GridViewAxisI.DataBind(); // } GridViewAxisI.DataSource = CurrentDiagnosis.Tables["DocumentDiagnosisCodes"]; GridViewAxisI.DataBind(); Page.Title = "Diagnosis Code"; }