/// <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());
}
