下面是我的代码:
public void BindPrintView()
{
ConnDB conn = new ConnDB(strConn);
ReportDocument Report = new ReportDocument();
TableLogOnInfo logOnInfo = new TableLogOnInfo();
Report.Load("path\\JobReport.rpt"); //为报表中的表设置连接信息。
logOnInfo.ConnectionInfo.ServerName = "mysevername";
logOnInfo.ConnectionInfo.DatabaseName = "mydatabasename";
logOnInfo.ConnectionInfo.UserID = "admin";
logOnInfo.ConnectionInfo.Password = "mypsw";
Report.Database.Tables[0].ApplyLogOnInfo(logOnInfo); string str = "SELECT * FROM table where id = '1044'";
DataSet ds = conn.ReturnDataSet(str);
Report.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = Report;
}
问题:按照我上面的sql语句,应该报表显示的是id为1044的记录,但是为什么还是显示了table里所有数据,为何?
public void BindPrintView()
{
ConnDB conn = new ConnDB(strConn);
ReportDocument Report = new ReportDocument();
TableLogOnInfo logOnInfo = new TableLogOnInfo();
Report.Load("path\\JobReport.rpt"); //为报表中的表设置连接信息。
logOnInfo.ConnectionInfo.ServerName = "mysevername";
logOnInfo.ConnectionInfo.DatabaseName = "mydatabasename";
logOnInfo.ConnectionInfo.UserID = "admin";
logOnInfo.ConnectionInfo.Password = "mypsw";
Report.Database.Tables[0].ApplyLogOnInfo(logOnInfo); string str = "SELECT * FROM table where id = '1044'";
DataSet ds = conn.ReturnDataSet(str);
Report.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource = Report;
}
问题:按照我上面的sql语句,应该报表显示的是id为1044的记录,但是为什么还是显示了table里所有数据,为何?
解决方案 »
- 一个asp.net问题!!!很急~~
- AJAX在IE6不能运行
- 相册的查看。。。上一张,下一张的问题。。。
- jmail中的deletesinglemessage(messageid)和downloadsinglemessage(index) 的问题
- asn.net 2.0 中global.asax文件的问题
- 自定义用户控件 问题
- 用HyperLink控件 点击之前怎么跳出个提示窗体 ?
- 我的datagrid不能翻页为何?
- 求教!DataGrid如果是在runtime时自动生成的列则提交时会自动清空DataGrid,为何?
- StringBuilder builder = new StringBuilder(); Using 怎么写?
- 弄了一下午了还是不行!本地没事,放到网上去就不行!
- 100关于DataList的问题
第一次搞这个,不明白??请指教
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
DataSet1 ds = new DataSet1();//实例化数据集
MyAdapter.Fill(ds,"employee)
MyConn.Close();
reportDocument1.Load("d:\\Report.rpt");
reportDocument1.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = reportDocument1;
CrystalReportViewer1.DataBind();
如:string sqlSearch="select * from union_view where .....";
.....