itemr_detail.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_itemR_detail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string id;
        id = Request["项目编号"];
       
        //id = "199104100013";
        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();
        item1 ds = new item1();
        SqlConnection conn = new SqlConnection(strProvider);
        conn.Open();
        string strSql = "select * from S_项目视图 where 项目编号="+id+"order by 署名位次";
        SqlDataAdapter dap = new SqlDataAdapter(strSql, conn);
        dap.Fill(ds, "S_项目视图");
        cr.Load("C:\\Inetpub\\wwwroot\\begin\\rept\\ReptItem2.rpt");
        cr.SetDataSource(ds);
        this.CrystalReportViewer1.ReportSource = cr;
    }
}