水晶报表

添加一个空的水晶报表，添加一个数据集DataSet1

 

demlo1.aspx.cs

namespace 水晶报表
{
    public partial class Demol3 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            string sql = "select sid,sname,sex,age from student";
            SqlDataAdapter adapter = new SqlDataAdapter(sql,constr);
            DataSet1 dateset1 = new DataSet1();
            adapter.Fill(dateset1,"DataTable1");

            ReportDocument doc = new ReportDocument();
            doc.Load( Server.MapPath( "CrystalReport3.rpt"));//将水晶报表加载到本网页
            doc.SetDataSource(dateset1);
            this.CrystalReportViewer1.ReportSource = doc;
            
        }
    }