对不起,没c币了。。。
string startTime = StartDate.Text.Trim();
DataSet2 ds = new DataSet2();
string connStr =“”;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
string SQL = "select * from [JDWater8000].[dbo].[WuJian] where days='" + startTime + "'";
SqlDataAdapter sda = new SqlDataAdapter(SQL, conn);
sda.Fill(ds, "WuJian");
SQL = "select * from [JDWater8000].[dbo].[ZhouXi] where days='" + startTime + "'";
sda = new SqlDataAdapter(SQL, conn);
//sda.SelectCommand.CommandText = "select * from ZhouXi where days='" + startTime + "'";
sda.Fill(ds, "ZhouXi");
}
ReportDocument rd = new ReportDocument();
//获取报表路径
string reportPath = Server.MapPath("");
rd.Load(reportPath);
//转义\
string local = "";
rd.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rd;
把 rd.SetDataSource(ds);改为rd.SetDataSource(ds.Tables[0]) 或者rd.SetDataSource(ds.Tables[1])都会正常显示,现在没有数据显示
在rpt文件中如果只显示一个表数据也是可以的,两个表数据就没有显示,请大神看下,什么原因呢