Home    |    Support   |   Site Map

Site search
 

See Also
Other Platforms
Features
Buy Now
Online Help
Demo
Licensing
Back

Barcode Data Binding in Windows Forms

Technologies used
  • Neodynamic Barcode Professional for Windows Forms (any version)
  • Microsoft .NET Framework 1.0 or greater
  • Microsoft Visual Studio .NET 2002 or 2003
  • Microsoft Visual Studio 2005
  • Microsoft Visual Studio 2005 Express Editions (VB, C#, J#, and C++)
In the following step by step guide we're going to create a simple Windows Forms application that accomplishes data binding tasks. In this sample we use Microsoft's Northwind database sample for SQL Server.
Follow these steps:
  • Ensure you have installed Barcode Professional for Windows Forms
  • Launch Visual Studio and create a new Windows Forms application
  • Open the default Form at design-time and add the following controls as is shown in the following figure:
    BarcodeDataBindingVB
  • Now, go to the form class and add the following code:
    • Declare this two members variables
      Visual Basic .NET
      Dim ds As DataSet
      Dim       bmbProducts As BindingManagerBase
      Visual C# .NET
      DataSet ds;
      BindingManagerBase bmbProducts;
    • Add the following code in the Form_Load event procedure VB.NET
      Visual Basic .NET
      Dim cnn As New System.Data.SqlClient.SqlConnection("server=(local);database=Northwind;integrated security=true")
      Dim sqlcmd As New System.Data.SqlClient.SqlCommand("SELECT Products.ProductName, Categories.CategoryName, Products.UnitPrice, Products.ProductID FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID", cnn)
      Dim da As New System.Data.SqlClient.SqlDataAdapter(sqlcmd)

      ds = New DataSet
      da.Fill(ds, "Products")

      bmbProducts = BindingContext(ds, "Products")

      TextBox1.DataBindings.Add("Text", ds, "Products.ProductName")
      TextBox2.DataBindings.Add("Text", ds, "Products.CategoryName")
      TextBox3.DataBindings.Add("Text", ds, "Products.UnitPrice")
      BarcodeProfessional1.DataBindings.Add("Code", ds, "Products.ProductID")

      BarcodeProfessional1.Text = ""
      BarcodeProfessional1.Symbology = Neodynamic.WinControls.BarcodeProfessional.Symbology.Industrial2of5
      Visual C# .NET
      System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection("server=(local);database=Northwind;integrated security=true");
      System.Data.SqlClient.SqlCommand sqlcmd = new System.Data.SqlClient.SqlCommand("SELECT Products.ProductName, Categories.CategoryName, Products.UnitPrice, Products.ProductID FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID", cnn);
      System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlcmd);

      ds = new DataSet();
      da.Fill(ds, "Products");

      bmbProducts = BindingContext[ds, "Products"];

      TextBox1.DataBindings.Add("Text", ds, "Products.ProductName");
      TextBox2.DataBindings.Add("Text", ds, "Products.CategoryName");
      TextBox3.DataBindings.Add("Text", ds, "Products.UnitPrice");
      BarcodeProfessional1.DataBindings.Add("Code", ds, "Products.ProductID");

      BarcodeProfessional1.Text = "";
      BarcodeProfessional1.Symbology = Neodynamic.WinControls.BarcodeProfessional.Symbology.Industrial2of5;
    • Add the following code in the Click event procedure for << Previous button
      Visual Basic .NET
      bmbProducts.Position -= 1
      Visual C# .NET
      bmbProducts.Position -= 1;
    • Add the following code in the Click event procedure for Next >> button
      Visual Basic .NET
      bmbProducts.Position += 1
      Visual C# .NET
      bmbProducts.Position += 1;
  • That's it. Run the app. You'll get something like the following:
    Barcode Data Binding
If you need more information or assistance, please contact our .
  Home   |    About us   |    Products   |   Support   |   Contact us   |   Privacy Policy
 Copyright © 2003 - 2009 Neodynamic S.R.L. All rights reserved.