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;
}错误是 无效报表文件路径、、、、 搞半天没搞出来。 求大神解决。、
解决方案 »
- 如何让背景图片的宽度拉伸变长?
- 一个正则,ASP区没人解答的出来.逼我回了DONET区重发一贴.应该不难
- 初手疑问
- 挥泪再求:在B/s系统中使用连接方式下载1MB多的excel文件所遇到的!诡异
- gridview的删除
- 关于session的头痛问题,在线急等~~
- [推荐] 用C#做了一个控件,请大家帮忙测试一下 http://www.xpGrid/Test
- IPAddress.Parse("192.168.1.2") 怎么加一个IP 192.168.1.1
- vs2012创建ef报错,麻烦各位看看怎么解决?
- 请教了
- Gridview数据更新显示问题
- 在asp.net中如何把不规则的Excel数据导入到sqlserver数据库中
private void Form1_Load(object sender, EventArgs e)
{
//推模式
string sql = “Select T1, T2, T3 FROM T where T1=”a””;
string DBConfig_sql = @”Data Source=SYWZSWL\SQLEXPRESS;Initial Catalog=Test;User ID=sa;Password=123456″;
DataSet ds = new DataSet();
SqlConnection sqlCon = new SqlConnection(DBConfig_sql);
SqlCommand sqlCmd = new SqlCommand(sql, sqlCon);
SqlDataAdapter sqlAd = new SqlDataAdapter();
sqlAd.SelectCommand = sqlCmd;
sqlAd.Fill(ds, “sql”);
crystalReport1.Load(Application.StartupPath + “CrystalReport.rpt”);
crystalReport1.SetDataSource(ds.Tables["sql"]);
//{?}中的参数可以不用赋值,即使赋了值也不起作用。
// CrystalReportSource1.ReportDocument.ParameterFields["Parm"].CurrentValues.AddValue(”1234567″);
crystalReport1.ParameterFields["Title"].CurrentValues.AddValue(”这时推模式的报表样例!”);
crystalReportViewer1.ReportSource = crystalReport1;
}
文章:http://www.cnblogs.com/chirs888888/archive/2010/03/18/1689269.html
String FillPath = Server.MapPath("../../Reports/ProductsMng.rpt");
Report.Load(FillPath);
Report.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.DisplayGroupTree = false;//获取或设置树视图是可见还是隐藏。
CrystalReportViewer1.HasToggleGroupTreeButton = false;//是否显示/隐藏组树按钮
CrystalReportViewer1.ReportSource = Report;
CrystalReportViewer1.DataBind();
(1)删除所有的 CrystalDecisions 程序集引用;
(2)删除所有的ReportDocument、CrystalReportViewer 组件;
(3)重新添加组件,自动生成新引用。
按照你这样做的, 我是创建了个文件夹rpt,里面是报表, String FillPath = Server.MapPath("/rpt/rptCarpark.rpt.rpt"); 这里错了, 无法映射路径。。 怎么搞的、 String FillPath = Server.MapPath("C.../rpt/rptCarpark.rpt.rpt"); 也不行