本帖最后由 Lenka.Guo 于 2017-1-5 11:23 编辑
可以的。1. 参考代码,CommandText 查询语句:
- public static PageReport AddDataSetDataSource(PageReport report)
- {
- // create DataSource for the report
- DataSource dataSource = new DataSource();
- dataSource.Name = "Reels Database";
- dataSource.ConnectionProperties.DataProvider = "OLEDB";
- dataSource.ConnectionProperties.ConnectString = ExpressionInfo.FromString(Properties.Resources.ConnectionString);
- //Create DataSet with specified query and load database fields to the DataSet
- DataSet dataSet = new DataSet();
- Query query = new Query();
- dataSet.Name = "Sample DataSet";
- query.DataSourceName = "Reels Database";
- query.CommandType = QueryCommandType.Text;
- query.CommandText = ExpressionInfo.FromString(Constants.cmdText);
- dataSet.Query = query;
- String[] fieldsList = new String[] { "MoviedID", "Title", "YearReleased", "MPAA" };
- foreach (string fieldName in fieldsList)
- {
- Field field = new Field(fieldName, fieldName, null);
- dataSet.Fields.Add(field);
- }
- //create report definition with specified DataSet and DataSource
- report.Report.DataSources.Add(dataSource);
- report.Report.DataSets.Add(dataSet);
- return report;
- }
复制代码
2. 或者后台代码连接数据库后,将查询出的结果集返回成 DataTable 或DataSet, 然后调用Document.LocateDataSource() 方法,将args.data =DataTable即可。
|