Simple .NET Integration With Google Spreadsheets
Simple .NET Integration With Google Spreadsheets
  • DataBind to Google Spreadsheets using standard Visual Studio wizards.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Use Google Spreadsheets as a simple real-time database to power .NET applications.
Download Beta

Getting Started with Google Spreadsheet ADO.NET Data Provider

Working with the new Google Spreadsheet ADO.NET Data Provider is easy. As a fully-managed .NET Data Provider, the Google provider integrates seamlessly with the Visual Studio development environment as well as any .NET application.

 

Visual Studio Integration - Server Explorer

As an ADO.NET Data Provider, Google Spreadsheet ADO.NET Data Provider can be used to access and explore Google Spreadsheets data directly from the Visual Studio Server Explorer.


It's easy. As a standard ADO.NET adapter developers can connect the Server Explorer to Google Spreadsheet ADO.NET Data Provider just like connecting to any standard database.

  1. Add a new Data Connection from the server explorer and select the Google Spreadsheets Data Source

  1. Configure the basic connection properties to access your Google Spreadsheets account data.

Explore all of the data available! Google Spreadsheet ADO.NET Data Provider makes it easy to access live Google Spreadsheets data from Visual Studio.

  1. After configuring the connection explore the feeds, views, and services provided by the Google Spreadsheets Data Source.
  2. These constructs return live Google Spreadsheets data that developers can work with directly from within Visual Studio!
 

Winforms DataGrid Integration

Connecting Web, Desktop, and Mobile .NET applications with Google Spreadsheets is just like working with SQL Server. It is even possible to integrate Google Spreadsheet ADO.NET Data Provider into applications without writing code.


Developers are free to access the Google Spreadsheet ADO.NET Data Provider in whatever way they like best. Either visually through the Visual Studio Winforms or Webforms designers, or directly through code.

  1. Developer can connect the Google Spreadsheets Data Source directly to form components by configuring the object's smart tags.

  1. Add a new Data Connection from the server explorer and select the Google Spreadsheets Data Source, and select the feed, view, or services you would like to connect the object to.

Done! It is just like connecting to SQL Server.

  1. Once the object is bound to the data source applications can easily interact with Google Spreadsheets data with full read/write (CRUD) support.