muhuiru 发表于 2016-5-11 16:30:52

wpf后台配置报表的数据源

我想在后台配置一下信息

Lenka.Guo 发表于 2016-5-11 16:56:20


Hi,
可以参考文档： http://www.gcpowertools.com.cn/docs/ActiveReports/AR9Guide/#!Documents/_225.htm

核心代码：
GrapeCity.ActiveReports.PageReportModel.DataSource myDataSource = newGrapeCity.ActiveReports.PageReportModel.DataSource();
      myDataSource.Name = "Example Data Source";
      myDataSource.ConnectionProperties.DataProvider = "SQLOLEDB ";
      myDataSource.ConnectionProperties.ConnectString ="Provider=sqloledb;user id=sa;data source=31.230.76.39.9601;initial catalog=H1_Manager;password=123456";   
   //setup the dataset
      GrapeCity.ActiveReports.PageReportModel.DataSet myDataSet = new GrapeCity.ActiveReports.PageReportModel.DataSet();
      GrapeCity.ActiveReports.PageReportModel.Query myQuery = new GrapeCity.ActiveReports.PageReportModel.Query();
      myDataSet.Name = "Example Data Set";
      myQuery.DataSourceName = "Example Data Source";
      myQuery.CommandType =GrapeCity.ActiveReports.PageReportModel.QueryCommandType.TableDirect;
      myQuery.CommandText =GrapeCity.ActiveReports.Expressions.ExpressionInfo.FromString("Product");
      myDataSet.Query = myQuery;


页: [1]
查看完整版本: wpf后台配置报表的数据源