} // Obsolete... #endregion #region User Controls #region Combo Box Events and Functions private void initDropDown(DropDownList dpID, string sql, int showSelect) { if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } SqlDataReader rsCombo = clsUtility.GetDataReader(sql); // if the showSelect flag is 1 then show the [Select] option, otherwise enter a blank option if (showSelect > 0) { // add a null option to each drop down list dpID.Items.Add(new ListItem("[Select]", "-1")); } else { dpID.Items.Add(new ListItem("", "")); } // get all of the values and text from the data reader while (rsCombo.Read()) { string val1 = rsCombo[0].ToString(); string val2 = rsCombo[1].ToString(); dpID.Items.Add(new ListItem(val2, val1)); } // close the reader rsCombo.Close(); }
} // Done...Tested #endregion #endregion #region Datagrid Events #region initGrid(DataGrid dgGrid, string strSQL, string pKey) private void initGrid(DataGrid dgGrid, string strSQL, string pKey) { if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } SqlDataReader rData = clsUtility.GetDataReader(strSQL); // set the grid's visible property to false to initialize the control dgGrid.Visible = false; int i; if (rData.HasRows) { dgGrid.Visible = true; for (i = 0; i < rData.FieldCount; i++) { BoundColumn objBC = new BoundColumn(); objBC.DataField = rData.GetName(i).ToString(); objBC.HeaderText = rData.GetName(i).ToString(); // use this function to make the primary key of the table hidden if (rData.GetName(i).ToString() == pKey) { objBC.Visible = false; } dgGrid.Columns.Add(objBC); } dgGrid.DataSource = rData; dgGrid.DataBind(); rData.Close(); } else { if (pKey == "MedicationID") { MedHdr.Visible = false; } if (pKey == "VitalSignID") { VitalHdr.Visible = false; } } // if in view mode then remove the Action column if (Session["mode"] != null && Session["mode"].ToString() == "view") { dgGrid.Columns[0].Visible = false;; } // cleanup rData.Close(); }
// need a method that will get the names of the textboxes, radio buttons, and drop down lists private void getFields(Control c, string strSQL) { if (AppMode) { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]); } else { clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]); } SqlDataReader rEncounter = clsUtility.GetDataReader(strSQL); while (rEncounter.Read()) { for (int i = 0; i < rEncounter.FieldCount; i++) { Control ctrl = getControl(c, rEncounter.GetName(i).ToString()); if (ctrl != null) { switch (ctrl.GetType().ToString()) { case "System.Web.UI.WebControls.TextBox": TextBox txtCtrl = new TextBox(); txtCtrl.Text = rEncounter.GetString(i); break; case "System.Web.UI.WebControls.DropDownList": DropDownList cboCtrl = new DropDownList(); cboCtrl.SelectedIndex = rEncounter.GetInt16(i); break; case "System.Web.UI.WebControls.RadioButtonList": RadioButtonList rdoCtrl = new RadioButtonList(); rdoCtrl.SelectedValue = rEncounter.GetString(i); break; } } } } rEncounter.Close(); }