Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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);
            }
        }