combit List & Label 29 - .NET Help
Programming Introduction / Tutorial / Examples
In This Topic
    Examples
    In This Topic

    Below you will find a number of practical examples for typical applications with List & Label.

     Designing a Label from an XML File

    A label project is opened in the Designer using the main Design function. An XML file is used as the data source.

    // Add List & Label namespaces
    using combit.Reporting;
    using combit.Reporting.DataProviders;
    
    ...
    
    // Create List & Label object
    using(ListLabel LL = new ListLabel())
    {
        // Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX";
     
        // Identify the data source
        XmlDataProvider xmlProvider = new XmlDataProvider(@"C:\temp\customers.xml");
        LL.DataSource = xmlProvider;
        LL.DataMember = "Customers";
     
        // Define project type
        LL.AutoProjectType = LlProject.Label;
     
        // Define some options (optional)
        // No more options to define
       
        // Execute main function: Design
        LL.Design();
       
        // Post-Processing (optional)
        // Do nothing currently
    }
    
    ' Add List & Label namespaces
    Imports combit.Reporting
    Imports combit.Reporting.DataProviders
    
    ...
    
    ' Create List & Label object
    Using LL As New ListLabel()
    
        ' Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX"
     
        ' Identify the data source
        Dim xmlProvider As New XmlDataProvider("C:\temp\customers.xml")
        LL.DataSource = xmlProvider
        LL.DataMember = "Customers"
     
        ' Define project type
        LL.AutoProjectType = LlProject.Label
     
        ' Define some options (optional)
        ' No more options to define
        
        ' Execute main function: Design
        LL.Design()
        
        ' Post-Processing (optional)
        ' Do nothing currently
    
    End Using 
    

     

     PDF export with options for a list of data from Microsoft SQL

    The main function Print is used to export a list project. PDF was defined as the standard export format and the PDF author was set to "John Doe" as options. A Microsoft SQL Server database is used as data source.

    // Add List & Label namespaces
    using combit.Reporting;
    using combit.Reporting.DataProviders;
    
    ...
    
    // Create List & Label object
    using(ListLabel LL = new ListLabel())
    {
        // Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX";
     
        // Identify the data source
        SqlConnection connection = new SqlConnection(Properties.Settings.Default.ConnectionString);
        SqlConnectionDataProvider sqlProvider = new SqlConnectionDataProvider(connection);
        LL.DataSource = sqlProvider;
     
        // Define project type
        LL.AutoProjectType = LlProject.List;
     
        // Define some options (optional)
        LL.ExportOptions.Add(LlExportOption.ExportTarget, "PDF");
        LL.ExportOptions.Add(LlExportOption.PdfAuthor, "John Doe");
       
        // Execute main function: Print
        LL.Print();
       
        // Post-Processing (optional)
        // Do nothing currently
    }
    
    ' Add List & Label namespaces
    Imports Reporting
    Imports combit.Reporting.DataProviders
    
    ...
    
    ' Create List & Label object
    Using LL As New ListLabel()
    
        ' Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX"
     
        ' Identify the data source
        Dim connection As New SqlConnection(Properties.Settings.Default.ConnectionString)
        Dim sqlProvider As New SqlConnectionDataProvider(connection)
        LL.DataSource = sqlProvider
     
        ' Define project type
        LL.AutoProjectType = LlProject.List
     
        ' Define some options (optional)
        LL.ExportOptions.Add(LlExportOption.ExportTarget, "PDF")
        LL.ExportOptions.Add(LlExportOption.PdfAuthor, "John Doe")
       
        ' Execute main function: Print
        LL.Print()
       
        ' Post-Processing (optional)
        ' Do nothing currently
    
    End Using 
    

     

     Silent export of a list from Microsoft SQL data with subsequent e-mail sending
    main function Export exports a list project with data from a Microsoft SQL Server database into PDF format. As Post-Processing, the export result is now carried out directly afterwards via the manual e-mail sending of List& Label.

    // Add List & Label namespaces
    using combit.Reporting;
    using combit.Reporting.DataProviders;
    
    ...
    
    // Create List & Label object
    using(ListLabel LL = new ListLabel())
    {
        // Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX";
     
        // Identify the data source
        SqlConnection connection = new SqlConnection(Properties.Settings.Default.ConnectionString);
        SqlConnectionDataProvider sqlProvider = new SqlConnectionDataProvider(connection);
        LL.DataSource = sqlProvider;
     
        // Define project type
        LL.AutoProjectType = LlProject.List;
     
        // Define some options (optional)
        // No more options to define
       
        // Execute main function: Export
        string exportFilename = @"C:\temp\export.pdf";
        ExportConfiguration exportConfiguration = new ExportConfiguration(LlExportTarget.Pdf, exportFilename, "simple.lst");
        LL.Export();
       
        // Post-Processing (optional): Sending eMail manual with List & Label
        using(MailJob mailJob = new MailJob())
        {
            mailJob.AttachmentList.Add(exportFilename);
            mailJob.To = "info@combit.net";
            mailJob.Subject = "Here is the report";
            mailJob.Body = "Please note the attachment.";
            mailJob.Provider = "XMAPI";
            mailJob.ShowDialog = true;
            mailJob.Send();
        }
    }
    
    ' Add List & Label namespaces
    Imports combit.Reporting
    Imports combit.Reporting.DataProviders
    
    ...
    
    ' Create List & Label object
    Using LL As New ListLabel()
    
        ' Licensing the List & Label component
        LL.LicensingInfo = "xXxXxXxX"
     
        ' Identify the data source
        Dim connection As New SqlConnection(Properties.Settings.Default.ConnectionString)
        Dim sqlProvider As New SqlConnectionDataProvider(connection)
        LL.DataSource = sqlProvider
     
        ' Define project type
        LL.AutoProjectType = LlProject.List
     
        ' Define some options (optional)
        ' No more options to define
       
        ' Execute main function: Export
        Dim exportFilename As String = "C:\temp\export.pdf"
        Dim exportConfiguration As New ExportConfiguration(LlExportTarget.Pdf, exportFilename, "simple.lst")
        LL.Export()
       
        ' Post-Processing (optional): Sending eMail manual with List & Label
        Using mailJob As New MailJob()
       
            mailJob.AttachmentList.Add(exportFilename)
            mailJob.To = "info@combit.net"
            mailJob.Subject = "Here is the report"
            mailJob.Body = "Please note the attachment."
            mailJob.Provider = "XMAPI"
            mailJob.ShowDialog = true
            mailJob.Send()
           
        End Using
       
    End Using
    

     

     Further examples
    Further examples and information can be found in the next step Further Information.