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);
  }
  													

• 最后運行您的應用程序，您會看到條形碼圖像顯示在報表上

本文翻譯自

更多條形碼相關產品請點擊>>