private ReportDocument oRpt;

protected void Page_Load(objectender,EventArgse)
{
   oRpt = new ReportDocument();
   string RptDir = Server.MapPath("CrystalReport2.rpt");
   oRpt.Load(RptDir);
   SqlConnectionon=newSqlConnection"server=.;database=northwind;uid=sa;pwd=;");
   con.Open();

   SqlDataAdapter da = new SqlDataAdapter("select * from categories", con); DataSet
   ds = new DataSet();
   da.Fill(ds, "categories");
   oRpt.SetDataSource(ds);

   this.CrystalReportViewer1.ReportSource = oRpt;

}   

protected void Page_Load(object sender, EventArgs e)
{
   TableLogOnInfo logOnInfo = new TableLogOnInfo();
   ReportDocument oRpt = new ReportDocument();
   String RptDir = Server.MapPath("CrystalReport.rpt"); ; //crystalreport1.rpt文件所在的绝对路径 
   oRpt.Load(RptDir);
   logOnInfo.ConnectionInfo.ServerName = ".";
   logOnInfo.ConnectionInfo.DatabaseName = "Northwind";
   logOnInfo.ConnectionInfo.UserID="sa";logOnInfo.ConnectionInfo.Password="wojiushixihuan";
   oRpt.Database.Tables[0].ApplyLogOnInfo(logOnInfo);

   this.CrystalReportViewer1.ReportSource = oRpt; 
}