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 bind the VIBlend Silverlight Data Grid?

Article Information

This article relates to the VIBlend DataGrid for Silverlight. It contains a complete example which illustrates how to create a custom data source and then bind the DataGrid control to it.

How To

Bind the DataGrid to business objects

Solution

To achieve this, follow these steps:

1. Specify the DataGrid's namespace.

xmlns:viblend="clr-namespace:VIBlend.Silverlight.Controls;assembly=VIBlend.Silverlight.DataGrid"

2. Create a new DataGrid instance and add its BoundFields.

<viblend:DataGrid x:Name="dataGrid" Margin="4" Grid.Row="1" AutoGenerateColumns="True">
    <viblend:DataGrid.BoundFields>
        <viblend:BoundField Text="Name" DataField="Name" Width="160" SortMode="Automatic"/>
        <viblend:BoundField Text="Date" DataField="Date" Width="140" SortMode="Automatic"/>
        <viblend:BoundField Text="Product" DataField="Product" Width="140" SortMode="Automatic"/>
        <viblend:BoundField Text="Quantity" DataField="Quantity" Width="90" SortMode="Automatic"/>
        <viblend:BoundField Text="Unit Price" DataField="UnitPrice" Width="72" SortMode="Automatic"/>
        <viblend:BoundField Text="Sales Amount" DataField="SalesAmount" Width="80" SortMode="Automatic"/>
    </viblend:DataGrid.BoundFields>
</viblend:DataGrid>

3. Create a class named EmployeeSalesRecord.

C#

public class EmployeeSalesRecord
{
    public EmployeeSaleRecord(string Name, DateTime Date, int ProductId, int Quantity)
    {
        this._name = Name;
        this._date = Date;
        this._productid = ProductId;
        this._quantity = Quantity;
    }

    #region Private Members
    private string _name;
    private DateTime _date;
    private int _productid;
    private int _quantity;
    #endregion

    #region Properties

    public string Name
    {
        get { return _name; }
        set { _name = value; }
    }

    public DateTime Date
    {
        get { return _date; }
        set { _date = value; }
    }

    public string Product
    {
        get { return productNames[_productid,0]; }
    }

    public int Quantity
    {
        get { return _quantity; }
        set { _quantity = value; }
    }

    public double UnitPrice
    {
        get
        {
            double unitPrice = double.Parse(productNames[_productid, 1]);
            return unitPrice;
        }
    }

    public double SalesAmount
    {
        get { return (double)_quantity * UnitPrice; }
    }


    #endregion
}

VB .NET

Public Class EmployeeSaleRecord
	Public Sub New(ByVal Name As String, ByVal [Date] As DateTime, ByVal ProductId As Integer, ByVal Quantity As Integer)
		Me._name = Name
		Me._date = [Date]
		Me._productid = ProductId
		Me._quantity = Quantity
	End Sub

	#Region "Private Members"
	Private _name As String
	Private _date As DateTime
	Private _productid As Integer
	Private _quantity As Integer
	#End Region

	#Region "Properties"

	Public Property Name() As String
		Get
			Return _name
		End Get
		Set(ByVal value As String)
			_name = value
		End Set
	End Property

	Public Property [Date]() As DateTime
		Get
			Return _date
		End Get
		Set(ByVal value As DateTime)
			_date = value
		End Set
	End Property

	Public ReadOnly Property Product() As String
		Get
			Return productNames(_productid,0)
		End Get
	End Property

	Public Property Quantity() As Integer
		Get
			Return _quantity
		End Get
		Set(ByVal value As Integer)
			_quantity = value
		End Set
	End Property

	Public ReadOnly Property UnitPrice() As Double
		Get
			Dim unitPrice_Renamed As Double = Double.Parse(productNames(_productid, 1))
			Return unitPrice_Renamed
		End Get
	End Property

	Public ReadOnly Property SalesAmount() As Double
		Get
			Return CDbl(_quantity) * UnitPrice
		End Get
	End Property
	#End Region
End Class

4. Create string arrays with sample data.

C#

string[] firstNames = new string[] 
{
    "Andrew",
    "Nancy",
    "Shelley",
    "Regina",
    "Yoshi",
    "Antoni",
    "Mayumi",
    "Ian",
    "Peter",
    "Lars",
    "Petra",
    "Martin",
    "Sven",
    "Elio",
    "Beate",
    "Cheryl",
    "Michael",
    "Guylène"
};

string[] lastNames = new string[] 
{
    "Fuller",
    "Davolio",
    "Burke",
    "Murphy",
    "Nagase",
    "Saavedra",
    "Ohno",
    "Devling",
    "Wilson",
    "Peterson",
    "Winkler",
    "Bein",
    "Petersen",
    "Rossi",
    "Vileid",
    "Saylor",
    "Björn",
    "Nodier"
};

static string[,] productNames = new string[,] 
{
    {"Black Tea", "1.95"},
    {"Green Tea", "1.95"},
    {"Caffè Espresso", "1.45"},
    {"Doubleshot Espresso", "1.75"},
    {"Caffè Latte", "2.25"},
    {"White Chocolate Mocha", "2.35"},
    {"Caramel Latte", "2.35"},
    {"Caffè Americano", "1.65"},
    {"Cappuccino", "2.10"},
    {"Espresso Truffle", "2.45"},
    {"Espresso con Panna", "1.81"},
    {"Peppermint Mocha Twist", "1.99"}
};

VB .NET

Private firstNames() As String = { "Andrew", "Nancy", "Shelley", "Regina", "Yoshi", "Antoni", "Mayumi", "Ian", "Peter", "Lars", "Petra", "Martin", "Sven", "Elio", "Beate", "Cheryl", "Michael", "Guylène" }

Private lastNames() As String = { "Fuller", "Davolio", "Burke", "Murphy", "Nagase", "Saavedra", "Ohno", "Devling", "Wilson", "Peterson", "Winkler", "Bein", "Petersen", "Rossi", "Vileid", "Saylor", "Björn", "Nodier" }

Private Shared productNames(,) As String = { {"Black Tea", "1.95"}, {"Green Tea", "1.95"}, {"Caffè Espresso", "1.45"}, {"Doubleshot Espresso", "1.75"}, {"Caffè Latte", "2.25"}, {"White Chocolate Mocha", "2.35"}, {"Caramel Latte", "2.35"}, {"Caffè Americano", "1.65"}, {"Cappuccino", "2.10"}, {"Espresso Truffle", "2.45"}, {"Espresso con Panna", "1.81"}, {"Peppermint Mocha Twist", "1.99"} }

5. Prepare DataGrid's data.

C#

public List<EmployeeSaleRecord> listSaleRecord = new List<EmployeeSaleRecord>();

private void PrepareGridData()
{
    const int rowsToLoad = 1000;
    listSaleRecord.Clear();

    Random rand = new Random();

    for (int i = 0; i < rowsToLoad; i++)
    {
        int productId = rand.Next(0, productNames.Length / 2 - 1);
        int quantity = rand.Next(1, 5);
        listSaleRecord.Add(new EmployeeSaleRecord(
            string.Format("{0} {1}",
            firstNames[rand.Next(0, firstNames.Length - 1)],
            lastNames[rand.Next(0, lastNames.Length - 1)]),
            DateTime.Now.AddDays(-rand.Next(10, 100)),
            productId,
            quantity)
            );
    }
}

VB .NET

Public listSaleRecord As List(Of EmployeeSaleRecord) = New List(Of EmployeeSaleRecord)()

Private Sub PrepareGridData()
	Const rowsToLoad As Integer = 1000
	listSaleRecord.Clear()

	Dim rand As New Random()

	For i As Integer = 0 To rowsToLoad - 1
		Dim productId As Integer = rand.Next(0, productNames.Length / 2 - 1)
		Dim quantity As Integer = rand.Next(1, 5)
		listSaleRecord.Add(New EmployeeSaleRecord(String.Format("{0} {1}", firstNames(rand.Next(0, firstNames.Length - 1)), lastNames(rand.Next(0, lastNames.Length - 1))), DateTime.Now.AddDays(-rand.Next(10, 100)), productId, quantity))
	Next i
End Sub

6. Bind the DataGrid.

C#

PrepareGridData();
dataGrid.ItemsSource = listSaleRecord;

VB .NET

PrepareGridData()
dataGrid.ItemsSource = listSaleRecord

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