• 水晶报表的装载和修改文本


    修改文本
    protected System.Web.UI.WebControls.Button btnChangeText;
      protected CrystalDecisions.Web.CrystalReportViewer cRV;
      myReport ReportDoc = new myReport();
      private void Page_Load(object sender, System.EventArgs e)
      {
       // 在此处放置用户代码以初始化页面
       string strProvider = "Server=(local);DataBase=Northwind;UID=sa;PWD=111";
       SqlConnection MyConn = new SqlConnection(strProvider);
       MyConn.Open();
       string strSelOrders = "Select * from orders";
       string strSelOrdersDetails = "Select * from [Order Details]";
       SqlDataAdapter daOrder = new SqlDataAdapter(strSelOrders,MyConn);
       SqlDataAdapter daOrderDetails = new SqlDataAdapter(strSelOrdersDetails,MyConn);
       DataSet ds = new DataSet();
       daOrder.Fill(ds,"orders");
       daOrderDetails.Fill(ds,"Order Details");
       
       ReportDoc.SetDataSource(ds);
       cRV.ReportSource = ReportDoc;
      }
    private void btnChangeText_Click(object sender, System.EventArgs e)
      {
       
       TextObject tb = (TextObject )ReportDoc.ReportDefinition.ReportObjects["Text2"];
       tb.Text = "订单号";
      }

    装载
    protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
      protected System.Web.UI.WebControls.Button btnLoad;
      protected System.Web.UI.HtmlControls.HtmlInputFile File1;
     
      private void Page_Load(object sender, System.EventArgs e)
      {
       // 在此处放置用户代码以初始化页面
       if(Session["filename"]!=null)
        CrystalReportViewer1.ReportSource = Session["filename"].ToString();

      }
    private void btnLoad_Click(object sender, System.EventArgs e)
      {
       string strName = File1.PostedFile.FileName;
       if(strName.Trim()!="")
       {
        CrystalReportViewer1.ReportSource = strName;
        Session["filename"] = strName;
       }

      }

  • 相关阅读:
    关于SQL Server中的DateTime类型和C#中的DateTime类型的一点小记录
    强类型DataSet的使用简明教程2
    byte[]转string的感悟
    ArrayList的Insert方法
    FormsAuthenticationTicket对象
    powerdesigner设置唯一键,但不是主键的方式
    KeyValuePair用法(转)
    如何在安装过程中部署DevExpress控件
    asp.net GridView手写事件,包括取主键、取值、更新、选择、删除
    序列化(Serialize)、反序列化(Deserialize)
  • 原文地址:https://www.cnblogs.com/ghd258/p/261688.html
Copyright © 2020-2023  润新知