VIBlend - .NET Controls and Components for Silverlight, WPF and Windows Forms

// Client Login

Home

Products

Downloads

Purchase

Support

Forum

About

Blog

WinForms Controls

WinForms DataGrid

Navigation Bars

Ribbon Interface

Calendar Control

TreeView Control

ComboBox Control

ListBox Control

Common Controls

Tab Control

OLAP Pivot Table

Free Controls

Silverlight Controls

Silverlight DataGrid

Scheduler Control

Ribbon Bar Control

Common Controls

Data Entry Controls

List Controls

ComboBox Control

Menu Control

TreeView Control

Navigation Bars

Tab Control

OLAP Pivot Table

Windows Phone 7

WPF Controls

WPF DataGrid

Data Entry Controls

Navigation Bars

WPF Tab Control

How to create alternating rows in the DataGridView?

Article Information

Article relates to VIBlend DataGridView for WinForms

How To

Apply different styles on alternating rows.

Solution

To achieve this, follow these steps:

1. Create a new instance of the vDataGridView via drag and drop from the toolbox or create it programmatically.

2. Bind the data grid to the Invoices table of the Northwind data base(NWind.mdb is shipped with the installation of the WinForms package)

C#

try
{
    NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter adapter = new IntegratedDemo.NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter();
    adapter.Fill(nwindDataSet_Inovices.Invoices);
}
catch (System.Exception ex)
{
    MessageBox.Show(ex.Message);
    return;
}

DataTable tbl = this.nwindDataSet_Inovices.Invoices;

Grid1.BoundFields.Clear();
Grid1.BoundPivotColumns.Clear();
Grid1.BoundPivotRows.Clear();
Grid1.BoundPivotValues.Clear();
Grid1.DataSource = null;

Grid1.PivotValuesOnRows = false;

int iColumns = 0;
foreach (DataColumn col in tbl.Columns)
{
    BoundField boundField = new BoundField(col.Caption, col.ColumnName);
    Grid1.BoundFields.Add(boundField);

    if (++iColumns == 5)
        break;
}

Grid1.DataSource = tbl.DefaultView;
Grid1.DataBind();
Grid1.ColumnsHierarchy.AutoResize();
Grid1.RowsHierarchy.AutoResize();

VB .NET
	
Try
    Dim adapter As NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter = New IntegratedDemo.NwindDataSet_InovicesTableAdapters.InvoicesTableAdapter()
    adapter.Fill(nwindDataSet_Inovices.Invoices)
    Catch ex As System.Exception
        MessageBox.Show(ex.Message)
    Return
End Try

Dim tbl As DataTable = Me.nwindDataSet_Inovices.Invoices

Grid1.BoundFields.Clear()
Grid1.BoundPivotColumns.Clear()
Grid1.BoundPivotRows.Clear()
Grid1.BoundPivotValues.Clear()
Grid1.DataSource = Nothing

Grid1.PivotValuesOnRows = False

Dim iColumns As Integer = 0
For Each col As DataColumn In tbl.Columns
    Dim boundField As New BoundField(col.Caption, col.ColumnName)
    Grid1.BoundFields.Add(boundField)

    iColumns += 1
    If iColumns = 5 Then
        Exit For
    End If
Next col

Grid1.DataSource = tbl.DefaultView
Grid1.DataBind()
Grid1.ColumnsHierarchy.AutoResize()
Grid1.RowsHierarchy.AutoResize()

3. Customize one of the built-in cell styles in order to set the cell's background color to be aqua.

C#

GridCellStyle style = GridTheme.GetDefaultTheme(VIBLEND_THEME.OFFICE2003BLUE).GridCellStyle;
style.FillStyle = new FillStyleSolid(Color.Aqua);

VB .NET

Dim style As GridCellStyle = GridTheme.GetDefaultTheme(VIBLEND_THEME.OFFICE2003BLUE).GridCellStyle
style.FillStyle = New FillStyleSolid(Color.Aqua)

4. Finally apply the cell style to the alternating grid rows.

C#

for (int i = 0; i < this.Grid1.RowsHierarchy.Items.Count; i++)
{
    if (i % 2 != 0)
    {
        this.Grid1.RowsHierarchy.Items[i].CellsStyle = style;
    }
}

VB .NET

For i As Integer = 0 To Me.Grid1.RowsHierarchy.Items.Count - 1
      If i Mod 2 <> 0 Then
            Me.Grid1.RowsHierarchy.Items(i).CellsStyle = style
      End If
Next i

Silverlight Controls	WinForms Controls	Knowledge Base	About Us

Silvelright DataGrid	Ribbon Interface	Technical Support	Blog
Silverlight Editors	WinForms DataGrid
Silverlight Ribbon Bar	Calendar	Downloads	Forum
Navigation Bars	Navigation Bars
Menu & ContextMenu	TreeView	Purchase Online	Client Login
ComboBox & ListBox	Tab Control
Silverlight Pivot Table	WinForms Pivot Grid	Request a feature	Report a bug