110,502
社区成员
发帖
与我相关
我的任务
分享
MySqlConnection conn = new MySqlConnection("server=192.168.0.xxx;database=xx;uid=xxx;pwd=xxx;charset=gb2312");
MyReportData Mydata = new MyReportData();
//DataSetByTime Mydata1 = new DataSetByTime();
//DataScoreInfo Mydata2 = new DataScoreInfo();
MySqlDataAdapter da;
// MySqlDataAdapter da1;
member member = new member();
private void frmPrint_Load(object sender, EventArgs e)
{
//显示报表内容
//int MemberId = Program.Num_id;
int MemberId = 1;
da = new MySqlDataAdapter("select a.MemberId as MemberId,MemberName,Score,Type from member as a left join memscore as b on a.memberid = b.memberid where a.memberid =" + MemberId + "", conn);
da.Fill(Mydata, "MyReportDataTable");
//da1 = new MySqlDataAdapter("select * from assessmentinfo where MemberId=" + MemberId + "", conn);
//da1.Fill(Mydata2, "DataScoreInfo");
crystalReport11.Load(Application.StartupPath + "CrystalReport1.rpt");
crystalReport11.SetDataSource(Mydata);
//crystalReport11.Subreports[0].SetDataSource(Mydata2);//将记录集传给子报表
crystalReportViewer1.ReportSource = crystalReport11;
crystalReportViewer1.ShowPrintButton = false;
}