Page History

...

Excerpt
Sets a DataSet as a data source to bind to a row in the template.

This method will return only one row of data for the column bound by the datamarker. You must insert a datamarker into the template for each column of data you want shown.

Signature

	C#
	C#

 public void BindRowData(System.Data.DataSet dataSource, System.String dataSourceName, DataBindingProperties property)

...

Example

Code Block

	csharp
	csharp
title	C#


          ExcelTemplate xlt = new ExcelTemplate();
          xlt.Open(@"C:\ExcelWriter\EmployeeOrdersTemplate.xls");
    
          //--- Bind the DataSet to the
          //--- %%=Orders.[Field] data marker.
          xlt.BindRowData(OrdersDS,
               "Orders",
               xlt.CreateDataBindingProperties());
          xlt.Process();
          xlt.Save(Page.Response, "EmployeeOrders.xls", false);

Code Block

	vb.net
	vb.net
title	vb.net


          Dim xlt As New ExcelTemplate()
          xlt.Open("C:\ExcelWriter\EmployeeOrdersTemplate.xls")
    
          '--- Bind the DataSet to the
          '--- %%=Orders.[Field] data marker.
          xlt.BindRowData(OrdersDS, _
               "Orders", _
               xlt.CreateDataBindingProperties())
          xlt.Process()
          xlt.Save(Page.Response, "EmployeeOrders.xls", False)

Space Shortcuts

Page tree

Versions Compared

Old Version 3

New Version 4

Key