博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

reportView控件的使用

Posted on 2011-04-16 08:49  VSTO之路  阅读(661)  评论(0编辑  收藏  举报

//在load事件中加入

SqlConnection myConn = new SqlConnection("server=.;uid=sa;pwd=xsdev;database=AIS_sy0101");
            SqlDataAdapter myda = new SqlDataAdapter("select * from ICSTOCKBILL WHERE FInterID=1780", myConn);
            DataSet myds = new DataSet();
            myConn.Open();
            myda.Fill(myds);
            myConn.Close();

            DataRow objdr = myds.Tables[0].Rows[0];
         

            ReportDataSource rds = new ReportDataSource("DataSet1_Orders", myds.Tables[0]);
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.DataSources.Add(rds);
            reportViewer1.LocalReport.Refresh();

            ReportParameter rptParaA = new ReportParameter("rptParaA", objdr["FBillNo"].ToString());
            reportViewer1.LocalReport.SetParameters(new ReportParameter[] { rptParaA });

            this.reportViewer1.RefreshReport(); //这句必须加入最后,否则每次都要点一下reportView的刷新才能显示数据

 

本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/ilovecx/archive/2010/11/15/6011228.aspx