水晶報表中子報表的數據綁定問題

2024-07-21 02:25:05

字體：大中小

來源：轉載

供稿：網友

是否被水晶報表中子報表的數據綁定問題折磨過？這也是我另一文章所說的問題

http://www.cnblogs.com/haozidong/archive/2004/10/20/54489.html

你可以通過單獨用代碼綁定子報表來解決這個問題。

string sconnectionstring = configurationsettings.appsettings["dbcommisms"];

sqlconnection sqlconn = new sqlconnection(sconnectionstring);
sqlcommand sqlcomm = new sqlcommand();
sqldataadapter dataadapter = new sqldataadapter();

sqlconn.open();

sqlcomm.connection = sqlconn;
sqlcomm.commandtype = commandtype.text;

dataadapter.selectcommand = sqlcomm;

dataset1 dataset = new dataset1();

string ssql = "select * from t_request where appli_id = '" + appli_id + "'";

sqlcomm.commandtext = ssql;
dataadapter.fill(dataset, "t_request");

ssql = "select * from t_request_inspection where appli_id = '" + appli_id + "'";

sqlcomm.commandtext = ssql;
dataadapter.fill(dataset, "t_request_inspection");

ssql = "select * from t_accept_inspection where appli_id = '" + appli_id + "'";

sqlcomm.commandtext = ssql;
dataadapter.fill(dataset, "t_accept_inspection");

subreportobject osubreport1 = orpt.reportfootersection1.reportobjects["subreport1"] as subreportobject;
reportdocument osub1 = osubreport1.opensubreport("inspection");

osub1.setdatasource(dataset);

subreportobject osubreport2 = orpt.reportfootersection2.reportobjects["subreport2"] as subreportobject;
reportdocument osub2 = osubreport1.opensubreport("survey");

osub2.setdatasource(dataset);

subreportobject osubreport3 = orpt.reportfootersection2.reportobjects["subreport3"] as subreportobject;
reportdocument osub3 = osubreport1.opensubreport("allonge");

osub3.setdatasource(dataset);

orpt.setdatasource(dataset);

oviewer.reportsource = orpt;

orpt 有三個字報表，dataset 有三個表。
上述代碼通過訪問每個字報表，來實現子報表數據綁定

上一篇：c#的namespace基礎（二）{轉載}

下一篇：經典常用的VB代碼標簽