Change the style columns

Dec 16, 2013 at 10:34 AM
I have two questions

Style

Is it possible to change the style of a single column? I need to completely disable the predefined styles (Themes) and for Each statement can establish an individual style (font, background color, etc.) ?


The following code, which is trying to change the style of the report generation
private void dgv_AutoGeneratingColumn_1(object sender, ExtendedGrid.Microsoft.Windows.Controls.DataGridAutoGeneratingColumnEventArgs e)
        {
            if (e.Column.Header.ToString() == "JNS_JNIP_KNIP")
            {
                e.Column.Header = "ABC";
                Style style = new Style(typeof(DataGridCell));
                Setter setter = new Setter(DataGridCell.ForegroundProperty, Brushes.Red);
                style.Setters.Add(setter);
                e.Column.CellStyle = style;

                var brushConverter = new BrushConverter();

                var bbSetter = new Setter(
                    DataGrid.BorderBrushProperty,
                    brushConverter.ConvertFromString("#FFDDDDDD"));

                var style2 = new Style(typeof(DataGrid));
                style2.Setters.Add(bbSetter);
            }     
        }
Performance

Is it possible that the report, which has about 25 columns and returns about 30 rows in the result generates about 10 seconds? This seems a very long time - everything depends on the number of columns - three columns in the case of this combination is generated quickly.


Below is the code which I connect a data source for the statement - if I do it correctly?
                cmd = new OracleCommand(aSql, conn);
                adapter = new OracleDataAdapter(cmd);
                ds = new DataSet();
                adapter.Fill(ds);                
                dgv.ItemsSource = ds.Tables[0].DefaultView;