Learn more
 

CData Software - Knowledge Base

Recent Google Sheets ADO.NET Articles

LINQ to Google Sheets

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Sheets Data Provider.

Deploy the ADO.NET Provider for Google Sheets on an SSRS Report Server

Connect to Google Sheets from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Visualize Google Sheets in TIBCO Spotfire through ADO.NET

Integrate Google Sheets into dashboards in TIBCO Spotfire.

DataBind Google Sheets to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Google Sheets with the DevExpress Windows Forms and Web controls to provide Google Sheets to a chart.

How to Access Google Sheets Using Entity Framework

This article shows how to access Google Sheets using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Export Data from SQL Server to Google Sheets through SSIS

Easily push SQL Server data to Google Sheets using the CData SSIS Tasks for Google Sheets.

Back Up Google Sheets to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Sheets. In this article, we will employ an SSIS workflow to populate a database with Google Sheets data.

Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid

Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.

Build an OLAP Cube in SSAS from Google Sheets

Establish a connection to Google Sheets data from SQL Server Analysis Services, and use the Google Sheets Data Provider to build OLAP cubes for use in analytics and reporting.

Publish Crystal Reports on Google Sheets

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Sheets.