iteam_total.aspx.cs

vc.net编程实现的教师数据库管理系统的实现

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using CrystalDecisions.Shared;
using CrystalDecisions.ReportSource;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportAppServer;

public partial class research_Iteam_total : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string strProvider = "Data Source=localhost;Initial Catalog=new;Persist Security Info=True;User ID=sa;Password=teacherdb";
        CrystalDecisions.CrystalReports.Engine.ReportDocument cr = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
        DataSet1 ds = new DataSet1();
        SqlConnection conn = new SqlConnection(strProvider);
        conn.Open();
        string strSql = "select * from S_项目视图";
        SqlDataAdapter dap = new SqlDataAdapter(strSql, conn);
        dap.Fill(ds, "S_项目视图");
        cr.Load("C:\\Inetpub\\wwwroot\\begin\\rept\\CrystalReport2.rpt");
        cr.SetDataSource(ds);
        this.CrystalReportViewer1.ReportSource = cr;
        //CrystalDecisions.CrystalReports.Engine.ReportDocument cr = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
        //cr.Load("C:\\Inetpub\\wwwroot\\google\\research\\CrystalReport2.rpt");
        //this.CrystalReportViewer1.ReportSource = cr;
    }
}