星空外围权威网站

Barcode Professional SDK for .NET最新版下载

使用ADO.NET数据表作为本地报表的数据源

• 添加一个DataSet项到项目中并命名为AdventureWorks.xsd

• 添加TableAdapter到DataSet（在DataSet设计页面单击右键选择add>TableAdapter...）

按照向导中的步骤。首先，请创建一个到AdventureWorks SQL Server数据库样本的连接然后选择下一步。之后，选择"Use SQL statements"并点击下一步。输入以下SQL语句：

SELECT ProductID, Name, ProductModel FROM Production.vProductAndDescription WHERE (CultureID = N'en')

• 添加一个新的自定义Column到刚刚创建的数据表，然后把它命名为Barcode，如下图所示：

• 改变Barcode column的数据类型为System.Byte[]

• 保存AdventureWorks.xsd文件

• 现在，创建一个新的Report项到项目中

• 报表的数据源应该如下图所示：

• 请将报表设计为下图的样式：

• 保存报表

• 现在，在设计时创建/打开一个windows窗口并拖拽一个ReportViewer控制器在上面设置本地报表为display

• 输入下列代码到Form_Load事件程序：

  VB

  private void Form1_Load(object sender, EventArgs e)
  {
      //Fill the datasource from DB    
      this.vProductAndDescriptionTableAdapter.Fill(this.AdventureWorks.vProductAndDescription);
  
      //Create an instance of Barcode Professional
      Neodynamic.SDK.BarcodeProfessional bcp = new Neodynamic.SDK.BarcodeProfessional();
      //Barcode settings
      bcp.Symbology = Neodynamic.SDK.Symbology.Code128;
      bcp.BarHeight = 0.25f;
  
      //Update DataTable with barcode image
      foreach(AdventureWorks.vProductAndDescriptionRow row in this.AdventureWorks.vProductAndDescription.Rows)
      {
          //Set the value to encode
          bcp.Code = row.ProductID.ToString();
          //Generate the barcode image and store it into the Barcode Column
          row.Barcode = bcp.GetBarcodeImage(System.Drawing.Imaging.ImageFormat.Png);
      }
          
      this.reportViewer1.RefreshReport();
  }
  													

  C#

  private void button1_Click(object sender, EventArgs e)
  {
      //Create an instance of ReportViewer
      Microsoft.Reporting.WinForms.ReportViewer viewer = new Microsoft.Reporting.WinForms.ReportViewer();
  
      //Set local report
      //NOTE: LocalReportWithBarcode refers to the namespace for the app.
      viewer.LocalReport.ReportEmbeddedResource = "LocalReportWithBarcode.Report1.rdlc";
  
      //Generate Data Source...
      //Fill the datasource from DB
      AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter ta = new AdventureWorksTableAdapters.vProductAndDescriptionTableAdapter();
      AdventureWorks.vProductAndDescriptionDataTable dt = new AdventureWorks.vProductAndDescriptionDataTable();
      ta.Fill(dt);
  
      //Create an instance of Barcode Professional
      Neodynamic.SDK.BarcodeProfessional bcp = new Neodynamic.SDK.BarcodeProfessional();
      //Barcode settings
      bcp.Symbology = Neodynamic.SDK.Symbology.Code128;
      bcp.BarHeight = 0.25f;
  
      //Update DataTable with barcode image
      foreach(AdventureWorks.vProductAndDescriptionRow row in dt.Rows)
      {
          //Set the value to encode
          bcp.Code = row.ProductID.ToString();
          //Generate the barcode image and store it into the Barcode Column
          row.Barcode = bcp.GetBarcodeImage(System.Drawing.Imaging.ImageFormat.Png);
      }
  
      //Create Report Data Source
      Microsoft.Reporting.WinForms.ReportDataSource rptDataSource = new Microsoft.Reporting.WinForms.ReportDataSource("AdventureWorks_vProductAndDescription", dt);
      viewer.LocalReport.DataSources.Add(rptDataSource);
  
      //Export to PDF. Get binary content.
      string mimeType;
      string encoding;
      string fileNameExtension;
      string[] streams;
      Microsoft.Reporting.WinForms.Warning[] warnings;
  
      byte[] pdfContent = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);
  
      //Creatr PDF file on disk
      string pdfPath = @"C:\temp\reportBarcode.pdf";
      System.IO.FileStream pdfFile = new System.IO.FileStream(pdfPath, System.IO.FileMode.Create);
      pdfFile.Write(pdfContent, 0, pdfContent.Length);
      pdfFile.Close();
  
      //Open PDF file
      System.Diagnostics.Process.Start(pdfPath);
  }
  													

• 最后运行您的应用程序，您会看到条形码图像显示在报表上

本文翻译自

更多条形码相关产品请点击>>