private void InitLanguageCombBox() { if (m_dbConnect.State == System.Data.ConnectionState.Closed) { m_dbConnect.Open(); } try { #region DML Command Setup for lbLanguage Combo SqlCommand cmd = new SqlCommand("Proc_GetLanguageCode", m_dbConnect); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); #endregion GVAR.FillCombox(cmbLanguage, dr, 0, 1, m_strLanguageCode); dr.Close(); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }
private void InitLanguageCombBox() { if (m_dbConnect.State == System.Data.ConnectionState.Closed) { m_dbConnect.Open(); } try { #region DML Command Setup for lbLanguage Combo string strSQL = "SELECT F_LanguageDescription,F_LanguageCode FROM TC_Language Order By F_Order"; SqlCommand cmd = new SqlCommand(strSQL, m_dbConnect); SqlDataReader dr = cmd.ExecuteReader(); #endregion GVAR.FillCombox(cmbLanguage, dr, 0, 1, m_strLanguageCode); dr.Close(); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } }