Itu harusnya yang tampil cuma 3, tapi yang tampil 9.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data.SqlClient;

using System.Data;



using System.Windows.Forms;

using CrystalDecisions.CrystalReports.Engine;

using CrystalDecisions.Shared;

namespace StokBarang

{

 class lapRelation

 {



 public static void laporan(string query, string query2)

 {

 SqlConnection conn = Koneksi.Conn;

 try 

 {

 conn.Open();

 SqlDataAdapter sda = new SqlDataAdapter(query, conn);

 SqlDataAdapter sda2 = new SqlDataAdapter(query2, conn);

 DataSet ds = new DataSet();

 sda.Fill(ds, "MsUser");

 sda2.Fill(ds, "MsBarang");



 relation myReport = new relation();

 myReport.Database.Tables[0].SetDataSource(ds);



 relationForm fr = new relationForm();

 fr.crystalReportViewer1.ReportSource = myReport;

 fr.Show();

 

 

 }

 catch (SqlException ex) 

 {

 MessageBox.Show(ex.Message, "error");

 }

 finally

 {

 conn.Close();

 }

 }

 }

}

private void button3_Click(object sender, EventArgs e)

 {

 string query = "SELECT MsUser.username FROM MsBarang INNER JOIN MsUser ON MsBarang.idUser = MsUser.idUser WHERE MsBarang.idUser = 2";

 string query2 = "SELECT MsBarang.NamaBarang , MsBarang.Stok , MsBarang.Harga FROM MsBarang WHERE MsBarang.idUser = 2";

 lapRelation.laporan(query, query2);

 }