Page History

Description

Excerpt
Sets a rectangular array of objects as a template data source.

Signature

	C#
	C#

 public void BindData(System.Object[,] arrayData, System.String[] columnNames, System.String dataSourceName, DataBindingProperties property)

Signature

	vb.net
	vb.net

Public Sub BindData(ByVal arrayData As Object(,), ByVal columnNames As String(), ByVal dataSourceName As String, ByVal [property] As DataBindingProperties)

Parameters

Param

	arrayData
	arrayData

A rectangular array of objects to use as the data source. By default, the first dimension corresponds to row and the second to column (that is, Object[row,column]).

Param

	columnNames
	columnNames

The names of the columns to get from the data source. If the columnNames parameter is null, field binding can only be performed by ordinal (for example, %%=DSN.#1 or %%=$DSN). If columnNames is specified, both ordinal field binding and named field binding can be used.

Param

	dataSourceName
	dataSourceName

The name of the set of data markers at which to insert the values imported from the data source.

Param

	property
	property

The DataBindingProperties object which contains information about how the data should be bound to the template.

Param

	property
	property

The DataBindingProperties object which contains information about how the data should be bound to the template. property Must be specified, but the DataBindingProperties need not be set beforehand. To bind data to a template with the default DataBindingProperties, pass in PowerPointTemplate.CreateDataBindingProperties() as the property value.

Exceptions

Exception

	ArgumentNullException
	ArgumentNullException

BindData will throw this exception if null (C#) or Nothing (VB.NET) is passed to the method.

Exception

	ArgumentException
	ArgumentException

Example

Code Block

	csharp
	csharp
title	C#


          PowerPointTemplate pptt = new PowerPointTemplate();
          pptt.Open(Page.MapPath("./ArrayBindingTemplate2.xls"));

          //--- Create an array of names and an array of data
          //--- source values and bind the data source to the
          //--- template data markers
          //--- %%=TwoDimArray.FirstName
          //--- %%=TwoDimArray.LastName
          //--- %%=TwoDimArray.Position
          string[,] twoDimNormal = {
               {"Nancy", "Davolio", "Sales Manager"},
               {"Michael", "Suyama", "HR Representative"},
               {"Adrian", "King", "IS Support"}
               };
          string[] names = {"FirstName", "LastName", "Position"};
          pptt.BindData(twoDimNormal,
               names,
               "TwoDimArray",
               pptt.CreateDataBindingProperties());

Code Block

	vbnet
	vbnet
title	VB

          Dim pptt As New PowerPointTemplate()
          pptt.Open(Page.MapPath("./ArrayBindingTemplate2.xls"))

          '--- Create an array of names and an array of data
          '--- source values and bind the data source to the
          '--- template data markers
          '--- %%=TwoDimArray.FirstName
          '--- %%=TwoDimArray.LastName
          '--- %%=TwoDimArray.Position
          Dim twoDimNormal(,) As String = New String(,){ _
               {"Nancy", "Davolio", "Sales Manager"}, _
               {"Michael", "Suyama", "HR Representative"}, _
               {"Adrian", "King", "IS Support"}}
          Dim names As String() = {"FirstName", "LastName", "Position"}
          pptt.BindData(twoDimNormal, _
               names, _
               "TwoDimArray", _
               pptt.CreateDataBindingProperties())

Space Shortcuts

Page tree

Versions Compared

Old Version 12

New Version Current

Key