/// <summary> /// Get standard configuration from database /// </summary> /// <returns>datatable with standard configuration</returns> public DataTable GetStandardConfigurationAsDataTable() { if (HasConnection) { try { DbCommand sqlCom = ConfigConnection.CreateCommand(); sqlCom.CommandText = "select * from " + Constants.CFG_TABLE_STANDARD; DbDataAdapter da; if (sqlCom is OleDbCommand) { da = new OleDbDataAdapter((OleDbCommand)sqlCom); } else { da = new SqlDataAdapter((SqlCommand)sqlCom); } DataTable dt = new DataTable(); da.Fill(dt); return(dt); } catch (Exception ex) { if (_needsStandardConfiguration) { MessageBox.Show("Loading standard configuration failed: " + Environment.NewLine + ex.Message); } } } return(new DataTable()); }