|
With as little as five lines of ExcelTemplate code, you can import data from a
database into an Excel report.
Technical Overview
ExcelTemplate can import data from ADO.NET DataSet, DataTable, DataView, OleDbDataReader, and SqlDataReader objects.
Note: ExcelTemplate does not close DataReader references. Be sure to close the database connection and DataReader in a finally block.
Choose an employee ID from the dropdown below. This value is used as a SQL
parameter to retrieve order information for a specific AdventureWorks2000
employee.
View source
View template
Click to run demo
Copyright 2005 © SoftArtisans, Inc. All Rights
Reserved.
|
