Powerful data API components for developing .NET-based data services

DataConnectors

Connect to cloud data sources from .NET. Connect directly to a variety of online services, including Salesforce, Google Analytics, and Dynamics 365, and integrate data into your .NET applications using ComponentOne DataConnectors.

DataCollection

Fast data binding and loading for large data sets Use powerful data binding components that provide filtering, grouping, sorting, and data virtualization for incrementally loading large data sets with ComponentOne DataCollection.

DataEngine

Leverage data analytics, slicing, and pivoting with in-memory caching to quickly extract, transform, and load (ETL) large and complex data sets with ComponentOne DataEngine.

CalcEngine

Provide Excel-like formula calculations everywhere in .NET ComponentOne CalcEngine provides built-in support for common functions to parse and evaluate expressions like Microsoft Excel.

TextParser

Automate Text Extraction in .NET Increase the productivity of your workflows by parsing text and extracting data from text and HTML files using ComponentOne TextParser.

Web API

Extend your apps with server-side Web APIs. ComponentOne Web APIs allow you to access and use data in native mobile and web apps hosted on your server, using a variety of APIs for document formats, imaging, reporting, and cloud services.

Desktop

This demo demonstrates how to analyze Dynamics 365 sales opportunity data in a .NET application to find opportunities for each product, salesperson, and fiscal quarter.

Integrate Google Analytics data into your dashboard

This blog focuses on retrieving data from Google Analytics and creating a dashboard in .NET WinForms. It also covers basic features like authentication, caching, and queries.

Extracting Product Information from Amazon Using .NET

Extract data from e-commerce websites like Amazon. This blog post demonstrates how to use the C1TextParser library to extract structured data from Amazon product pages for use in a .NET app.

Creating a .NET Salesforce OData Service

Learn how to build an OData service in ASP.NET Core to periodically cache data in your .NET application to avoid excessive calls to Salesforce or any online CRM.

Integrate QuickBooks Online Data Using ADO.NET

This blog post will help you understand how to connect to QuickBooks Online data using the ADO.NET C1DataConnector for QuickBooks Online and cover basic features including authentication, querying, and caching.

Convert Excel files stored in the cloud to JSON

Users can connect to various cloud storage services, including Google and DropBox, through a single API. The Excel API can create, split, merge, find, and replace Excel files, and convert them to various formats, such as CSV, JSON, and XML.

Implementing a smart tag system using TextParser

Visualizing Dynamics 365 Sales Data in a .NET Pivot Grid

The Dynamics 365 ADO.NET connector is useful when used with analytical UI controls, such as the ComponentOne OLAP/Pivot control. These UI controls allow users to analyze records in Dynamics.

Importing Data from Salesforce to QuickBooks Online

Users often need to import data from Salesforce into QuickBooks Online. This blog post will explore how to do this using C1DataConnectors and ADO.NET.

In-memory analytics using Salesforce Data and C1DataEngine

This blog post shows you how to import data from Salesforce and apply a pivot transformation, including aggregating values in a single column, using C1DataConnectors and C1DataEngine.

How to Build Leads for Opportunity Salesforce Reports Using .NET

This blog explains how to bind a FlexReport to an Opportunity data table in Salesforce using the FlexReport Designer, converting available leads to opportunities.

How to paste and format a formatted hyperlink in a WPF text editor

Explains how to combine the WPF RichTextBox component with TextParser to automatically convert and format URLs into hyperlinks within a rich text editing application.

Pivot Transformation Using C1DataEngine

Apply pivot transformations, such as grouping and aggregation, to large data sets. Using optimization techniques like column-oriented and memory-mapped files, C1DataEngine provides fast data analysis of large data sets.

Creating an Excel-Like Formula Input Bar in .NET WinForms

If you've used Excel before, creating and evaluating formulas using C1CalcEngine will be simple and familiar. This section demonstrates how to create a simple expression and obtain its result using the Evaluate function.

Automatically extract text from HTML emails

Emails follow an expected structure and can be automatically parsed with predictable accuracy. C1TextParser allows you to record or analyze individual information from emails.

Query data from Salesforce and display it in FlexGrid

Learn how to use data in Salesforce and perform operations that aren't available out of the box, like sorting, grouping, and caching.

Integrate Dynamics 365 CRM with .NET using Entity Framework Core

Access data and update Dynamics 365 Sales entities using Entity Framework Core and LINQ. Explore various use cases for accessing Microsoft Dynamics 365 Sales data outside of CRM, such as reports, BI dashboards, and data processing application integrations.

How to implement CRUD operations using the CSV service in .NET

Learn how to create a .NET web service to process CSV data files and display them in an ASP.NET Core MVC UI.