iteam_detail.aspx.cs

来自「vc.net编程实现的教师数据库管理系统的实现」· CS 代码 · 共 48 行

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 CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportAppServer;
using System.Data.SqlClient;

public partial class research_iteam_detail : System.Web.UI.Page
{
    string strConnect = "Data Source=localhost;Initial Catalog=new;Persist Security Info=True;User ID=sa;Password=teacherdb";
    //private string strConnect = ConfigurationSettings.AppSettings["newConnectionString"];
    protected void Page_Load(object sender, EventArgs e)
    {
       // if(!IsPostBack)
       // {
        CrystalDecisions.CrystalReports.Engine.ReportDocument cr = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
        iteam ds = new iteam();
        SqlConnection objConnection = new SqlConnection(strConnect);
        objConnection.Open();
        string strSql = "select * from S_项目视图 where 署名位次='1'";
        SqlDataAdapter dap = new SqlDataAdapter(strSql, objConnection);
        dap.Fill(ds, "S_项目视图");
        cr.Load("C:\\Inetpub\\wwwroot\\begin\\rept\\ReptIteam.rpt");
        cr.SetDataSource(ds);
        this.CrystalReportViewer1.ReportSource = cr;
        objConnection.Close();
        // ds.Clear();
      /*  }
        else
        {
            CrystalDecisions.CrystalReports.Engine.ReportDocument cr = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            iteam ds = new iteam();
            cr.Load("C:\\Inetpub\\wwwroot\\begin\\rept\\ReptIteam.rpt");
            cr.SetDataSource(ds);
            this.CrystalReportViewer1.ReportSource = cr;
        }*/
    }

}