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

Home

Products

Downloads

Support

About

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

WPF Controls

WPF DataGrid

Data Entry Controls

Navigation Bars

WPF Tab Control

How to format the value of a DataGridView cell?

Article Information

Article relates to VIBlend DataGridView for WinForms

How To

Format cells values in vDataGridView for WinForms

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 DataGrid to the Northwind Invoices table( Nwind.mdb is included in the download of the VIBlend Controls for WinForms package).

C#

NwindDataSetTableAdapters.InvoicesTableAdapter adapter = new DataBindingAndEditors.NwindDataSetTableAdapters.InvoicesTableAdapter();
adapter.Fill(nwindDataSet1.Invoices);

DataTable tbl = this.nwindDataSet1.Invoices;

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

for (int i = 0; i < tbl.Columns.Count; i++)
{
    DataColumn col = tbl.Columns[i];
    BoundField boundField = new BoundField(col.Caption, col.ColumnName);
    vDataGridView1.BoundFields.Add(boundField);
}

vDataGridView1.DataSource = tbl;

vDataGridView1.ColumnsHierarchy.AutoResize();
vDataGridView1.RowsHierarchy.AutoResize();
vDataGridView1.Refresh();

VB .NET

Dim adapter As NwindDataSetTableAdapters.InvoicesTableAdapter = New DataBindingAndEditors.NwindDataSetTableAdapters.InvoicesTableAdapter()
adapter.Fill(nwindDataSet1.Invoices)

Dim tbl As DataTable = Me.nwindDataSet1.Invoices

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

Dim i As Integer = 0

Do While i < tbl.Columns.Count
    Dim col As DataColumn = tbl.Columns(i)
    Dim boundField As BoundField = New BoundField(col.Caption, col.ColumnName)
    vDataGridView1.BoundFields.Add(boundField)
    i += 1
Loop

vDataGridView1.DataSource = tbl

vDataGridView1.ColumnsHierarchy.AutoResize()
vDataGridView1.RowsHierarchy.AutoResize()
vDataGridView1.Refresh()

3. Set a custom format string to an entire grid column.

C#

int columnIndex = this.nwindDataSet1.Invoices.Columns.IndexOf(this.nwindDataSet1.Invoices.RequiredDateColumn);
vDataGridView1.ColumnsHierarchy.Items[columnIndex].CellsFormatString = "{0:yyyy/MMMM/dd}";

VB .NET 

Dim columnIndex As Integer = Me.nwindDataSet1.Invoices.Columns.IndexOf(Me.nwindDataSet1.Invoices.RequiredDateColumn)
vDataGridView1.ColumnsHierarchy.Items(columnIndex).CellsFormatString = "{0:yyyy/MMMM/dd}"

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	Report a bug	Client Login
ComboBox & ListBox	Tab Control
Silverlight Pivot Table	WinForms Pivot Grid	Request a feature