如何在Crystal报表中访问2个表的数据 [英] how data of 2 tables can be accessed in crystal reports

问题描述

我正在使用C#.NET和SQL SERVER 2008开发桌面应用程序.
我有2个标签，分别是Media _Method和Target_Audience

我希望特定报表上的两个表都可以显示这些数据.我尝试过以下代码

I am working on desktop application using C#.NET and SQL SERVER 2008
i have 2 tabes namely Media _Method and Target_Audience

i want that data should get displayed of both tables on particular report.i Have tried following code

CrystalReport1  objRpt = new CrystalReport1();
 
string connString = "Data Source=SW-PC-20;Initial Catalog=PSM;Integrated Security=True";
SqlConnection Conn = new SqlConnection(connString);
SqlDataAdapter adepter = new SqlDataAdapter("select m.Media_method_ID,m.Media_Name ,t.Target_Audience_ID,t.Target_Audience   from Media_Method m,Target_Audience t where m.Media_method_ID=t.Media_method_ID", connString);

  DataSet1 Ds = new DataSet1();
        
 adepter.Fill(Ds, "Media_Method"+"Target_Audience");
 
 objRpt.SetDataSource(Ds);
   crystalReportViewer1.ReportSource = objRpt;

推荐答案

查看此链接

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm [ ^ ]

see this link

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm[^]

这篇关于如何在Crystal报表中访问2个表的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！