SetDataSource

SetDataSource(string, ICellsDataTable)

Sets data source of a ICellsDataTable object.

public void SetDataSource(string dataSource, ICellsDataTable cellsDataTable)
Parameter Type Description
dataSource String The name of the data source.
cellsDataTable ICellsDataTable data table.

See Also


SetDataSource(DataSet)

Sets data source of a DataSet object.

public void SetDataSource(DataSet dataSet)
Parameter Type Description
dataSet DataSet DataSet object

Examples


[C#]

//Create a connection object, specify the provider info and set the data source.
OleDbConnection con = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=Northwind.mdb");
//Open the connection object.
con.Open();
//Create a command object and specify the SQL query.
OleDbCommand cmd = new OleDbCommand("Select * from [Order Details]", con);
//Create a data adapter object.
OleDbDataAdapter da = new OleDbDataAdapter();
//Specify the command.
da.SelectCommand = cmd;
//Create a dataset object.
DataSet ds = new DataSet();
//Fill the dataset with the table records.
da.Fill(ds, "Order Details");
//Create a datatable with respect to dataset table.
DataTable dt = ds.Tables["Order Details"];
//Create WorkbookDesigner object.
WorkbookDesigner wd = new WorkbookDesigner();
//Open the template file (which contains smart markers).
wd.Workbook = new Workbook("SmartMarker_Designer.xls");
//Set the datatable as the data source.
wd.SetDataSource(dt);
//Process the smart markers to fill the data into the worksheets.
wd.Process(true);
//Save the excel file.
wd.Workbook.Save("outSmartMarker_Designer.xls");

[Visual Basic]

'Create a connection object, specify the provider info and set the data source.
Dim con As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=Northwind.mdb")
'Open the connection object.
con.Open()
'Create a command object and specify the SQL query.
Dim cmd As OleDbCommand = New OleDbCommand("Select * from [Order Details]", con)
'Create a data adapter object.
Dim da As OleDbDataAdapter = New OleDbDataAdapter()
'Specify the command.
da.SelectCommand = cmd
'Create a dataset object.
Dim ds As DataSet = New DataSet()
'Fill the dataset with the table records.
da.Fill(ds, "Order Details")
'Create a datatable with respect to dataset table.
Dim dt As DataTable = ds.Tables("Order Details")
'Create WorkbookDesigner object.
Dim wd As WorkbookDesigner = New WorkbookDesigner()
'Open the template file (which contains smart markers).
Dim workbook As Workbook = New Workbook("SmartMarker_Designer.xls")
wd.Workbook = workbook
'Set the datatable as the data source.
wd.SetDataSource(dt)
'Process the smart markers to fill the data into the worksheets.
wd.Process(True)
'Save the excel file.
wd.Workbook.Save("outSmartMarker_Designer.xls")

See Also


SetDataSource(DataTable)

Sets data source of a DataTable object.

public void SetDataSource(DataTable dataTable)
Parameter Type Description
dataTable DataTable DataTable object

See Also


SetDataSource(string, DataView)

Sets data source of a DataView object and binds it to a data source name.

public void SetDataSource(string dataSourceName, DataView dataView)
Parameter Type Description
dataSourceName String Data source name.
dataView DataView DataView object.

See Also


SetDataSource(DataView)

Sets data source of a DataView object.

public void SetDataSource(DataView dataView)
Parameter Type Description
dataView DataView DataView object

See Also


SetDataSource(string, IDataReader, int)

Sets data source of a IDataReader object.

public void SetDataSource(string name, IDataReader dataReader, int rowCount)
Parameter Type Description
name String The data source map name.
dataReader IDataReader IDataReader object
rowCount Int32 The number of the data rows. If the smart marker does not contains “noadd”, we have to insert rows by the row count for performance issue and dynamic repeated formulas. -1 means the param is useless.

See Also


SetDataSource(string, object)

Sets data binding to a variable.

public void SetDataSource(string variable, object data)
Parameter Type Description
variable String Variable name created using smart marker.
data Object Source data.

See Also


SetDataSource(OleDbConnection)

Sets data source of a OleDbConnection object.

public void SetDataSource(OleDbConnection connection)
Parameter Type Description
connection OleDbConnection OleDbConnection object

See Also


SetDataSource(SqlConnection)

Sets data source of a SqlConnection object.

public void SetDataSource(SqlConnection connection)
Parameter Type Description
connection SqlConnection SqlConnection object

See Also