Using the new Visual Studio design-time integration for C1DataConnectors, we can populate FlexGrid, FlexPivot, and FlexChart controls without writing a single line of code.

Integrate DataConnectors with Visual Studio so that you can easily connect to online data sources such as Salesforce, Dynamics 365 Sales, OData, and Kintone through Server Explorer.

Through this code-less integration, you can drag and drop tables on a dataset in the designer and connect to data-aware controls like grids, charts, and report designers such as Crystal Reports.

You need to have the latest version of the ComponentOne Control Panel on your system and ensure that Data Services is installed up to the latest available version. Download the ComponentOne Control Panel if you haven’t done so already.

Try ComponentOne Studio

Download the latest version of ComponentOne Studio Enterprise

Download Now!

data service

After installation, DataConnectors will integrate into Visual Studio. The steps below describe how to create a database connection:

  1. Begin by opening a WinForms Application in Visual Studio. From the “View” tab, select “Server Explorer.”

real

  1. In the Server Explorer, select Data Connections and click the “Add Connection” icon to connect to the database, as shown in the following image:

explorer

  1. The “Add Connection” window will open. Next to “Data source:”, click on the “Change…” button.

connection

  1. In the “Choose Data Source” dialog, choose a new data source and/or ADO.NET data provider and click “OK”. In this example, we choose “C1 ODATA Data Source” to connect to the OData service. At this point, you may be asked by the new provider for credentials, depending on how it’s configured.

data source

  1. In the “Add Connection” dialog, navigate to the “ConnectionString” property under “Data”, enter your connection string (without cache settings) and click “Test Connection,” as shown in the image below. Determine the cache settings in code or through the connection string in the configuration file.

modify

  1. Now that we have a successful connection, click “OK”. You can view the connected database (as shown in the following image) and create a new data source:

service

  1. In the design view, drag and drop DataGridView control on the Form.

windows forms

  1. Select the DataGridView control and click on the smart tag in the top-right corner to open the “C1DataGridView Tasks” menu.

select

  1. Click on the “Choose Data Source” drop-down button and select the “Add Project Data Source…” option to open the “Data Source Configuration Wizard.”

datagrid view

  1. On the “Choose a Data Source Type” page, select “Database” and click “Next.’

data source

  1. On the “Choose a Database Model” page, select “Dataset” and click “Next.”

wizard

  1. On the “Choose Your Data Connection” page, click “Next” as your data connection is already set as “C1 OData [OData Server V4].”

connection

  1. Save the connection string in the application configuration file by selecting the “Yes, save the connection as” check box.

string

  1. Click “Next” to switch to the “Choose Your Database Objects” page.

  2. Choose a table from the “Tables” node and click “Finish”.

database

You now have a dataset added to your application – binding the DataGridView control to the selected table from the data source without having to write a line of code.

result

Try ComponentOne Studio

Download the latest version of ComponentOne Studio Enterprise

Download Now!