ActiveReport报表更改连接字符串及参数

PageReport pr = new PageReport (new FileInfo("报表路径")); //报表路径如../Order/OrderSale.rdlx

if(pr != null)

{

foreach(var dataSource in pr.DataSources)

{

dataSource.ConnectionProperties.DataProvider == "ODBC";

dataSource.ConnectionProperties.ConnectString = ExpressionInfo.FromString("Driver={MySQL ODBC 5.3 UNICODE Driver}; Server=192.168.100.100;Port=3306;Database=ShuJuKu;User=UserName,PWD=pwd;Option=3;charset=UTF8");

}

}

 

pr.Report.ReportParameters[0].DefaultValue.Values.Clear(); //清除第一个参数的值

pr.Report.ReportParameters[0].DefaultValue.Values.Add("参数值");  //赋值

 

//报表控件展示

具体看使用的什么报表控件

 

转载于:https://www.cnblogs.com/ouylvr0625/p/9448725.html