private void BindReport()
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=TestYP;User ID=sa;Password=ouwen");
con.Open();
ReportDocument rpt = new ReportDocument();
DataSet ds = new DataSet();
string sql = "SELECT * FROM Carpark INNER JOIN District ON Carpark.DISTRICT_ID = District.DISTRICT_ID";
SqlDataAdapter MyAdapter = new SqlDataAdapter(sql, con);
MyAdapter.Fill(ds,"ReproDataTable1");
rpt.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = rpt;
}
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=TestYP;User ID=sa;Password=ouwen");
con.Open();
ReportDocument rpt = new ReportDocument();
DataSet ds = new DataSet();
string sql = "SELECT * FROM Carpark INNER JOIN District ON Carpark.DISTRICT_ID = District.DISTRICT_ID";
SqlDataAdapter MyAdapter = new SqlDataAdapter(sql, con);
MyAdapter.Fill(ds,"ReproDataTable1");
rpt.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = rpt;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货