how data of 2 tables can be accessed in crystal reports

See more:

C#3.0

.NET3.5

C#

.NET

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;