VB .NET Google Drive Api Source Code Example


VB .NET Google Drive Api Source Code Example

VB .NET Google Drive Api Source Code Example
VB .NET Google Drive Api Source Code Example

Requirements

Visual Basic 2012 [recommended VS 2015] or above (Visual Studio 2019) from here
Visual Basic previous Example from here
Google Account from here
.NET Framework 4.5+ or above. "Async Programming"
Google Drive Api [Google.Apis.Drive.v3] from NuGet here

Open VB 2015 Project in VB 2019 

Can I open / migrate Visual Basic 2015 Project Source Code with Visual Basic 2019 ?
The answer is Yes, if you want to more details about VB 2015 to VB 2019 migration, please read

VB.NET Google Drive Api v3 post key points

Project description

I will use the VB.NET example from previous post [Backup Database to Google Drive] to add another functionality to it. I will add Backup Database to Google Drive [ToolStripMenuItem]
VB .NET Google Drive Api Source Code Example
VB .NET Google Drive Api Source Code Example
When a user press [ToolStripMenuItem -> Backup to Google Drive] : The VB .NET application does the following :
  • Checks for Internet Connection Status.
  • Connects to Google Drive project created in Google developer section [App Console].
  • Uploads the Microsoft Access 2007 (*.accdb) Database file from previous post to remote folder [/Backups] created manually by me in my Google Drive account.
  • Returns a string [File uploaded to Google Drive] to verify [UploadFile] method.

Installing Google Drive Api (Google.Apis.Drive.v3) from Visual Studio 2015

To install latest Google.Apis.Drive.v3 from Visual Basic 2015 :

VB .NET Google Drive Api installation using NuGet in VS2015
VB .NET Google Drive Api installation using NuGet in VS2015

  • In the console manager in Visual Studio, paste the PM Code and press <Enter>
VB .NET Google.Apis.Drive.v3 installation using NuGet in VS2015
VB .NET Google.Apis.Drive.v3 installation using NuGet in VS2015
  • Wait for Google.Apis.Drive.v3 download to 100% complete and restart Visual Studio 2015, to ensure that you Successfully installed 'Google.Apis.Drive.v3' to [HierarchicalTreeView] project.
  • Now, in your Visual Basic 2015 Solution Explorer panel [References] would looks something like this :
VB .NET Google.Apis.Drive.v3 installation using NuGet in VS2015 Reference
VB .NET Google.Apis.Drive.v3 installation using NuGet in VS2015 Reference

Create Google Console Project for .NET to use Google Drive Api.

VB .NET Google Api Console Create new project
Google Api Console Create new project

VB .NET Google Drive Api Project Overview
Google Drive Api Project Overview
In the above picture, make sure you Google Drive Api is present in the bottom of the page

Using OAuth 2.0 to Access Google APIs

As stated in Google Developer Guide :
Installed applications 
The Google OAuth 2.0 endpoint supports applications that are installed on devices such as computers, mobile devices, and tablets. When you create a client ID through the Google API Console, specify that this is an Installed application, then select Android, Chrome App, iOS, or "Other" as the application type. The process results in a client ID and, in some cases, a client secret, which you embed in the source code of your application. (In this context, the client secret is obviously not treated as a secret.) The authorization sequence begins when your application redirects a browser to a Google URL; the URL includes query parameters that indicate the type of access being requested. Google handles the user authentication, session selection, and user consent. The result is an authorization code, which the application can exchange for an access token and a refresh token. The application should store the refresh token for future use and use the access token to access a Google API. Once the access token expires, the application uses the refresh token to obtain a new one.
 For more details (Oauth for Mobile and Desktop Apps)

OAuth 2.0 for Desktop applications 'Installed Applications' ?

As stated here (https://developers.google.com/identity/protocols/oauth2/native-app) 'OAuth 2.0 Desktop Apps' : 
This authorization flow is similar to the one used for web server applications. The main difference is that installed apps must open the system browser and supply a local redirect URI to handle responses from Google's authorization server.

What do we need from Google Console Api ?

VB.NET Google Console Api - Drive Api
VB.NET Google Console Api - Drive Api

    • In order to start coding your application you need some data from Google Console Api to use in your VB.NET project :
You need to create OAuth 2.0 client IDs from Credentials section. For installed applications (like desktop applications) you will not need to specify any information in the OAuth consent screen only the application name and your Google email address.
Your Google Console Api Credentials Section


  1. Application Name (Backup-DB-Desktop) in the top of the page.
  2. Client ID (something.apps.googleusercontent.com)
  3. Client Secret (Found when you click on OAuth Name)

VB.NET Google Drive Api Desktop Project Code

  • We create a Service using those credentials above
  • We upload the file
  • Check your Google Drive account associated with your original Google Account Email.
  • I used a small file to upload.
  • I will also include "Google Drive Resumable Upload" ChunkedUpload() method in my source code example for my 13mb Access database file.

VB.NET Google Drive Api Desktop Project Run

When you run the application for the first time, you will go through some security issues like :
  • Google will prompt you to verify access from another application
  • Refresh AccessToken is done via your browser, so you will notice that your browser will open for refreshing accesstoken
  • Those would occur only once.

Try the QuickStart example first, this example is designed only for testing.


vb.net google drive api v3 OAuth 2.0 Quick Start Example Permission
vb.net google drive api v3 OAuth 2.0 Quick Start Example Permission

vb.net google drive api v3 OAuth 2.0 allow access
vb.net google drive api v3 OAuth 2.0 allow access

vb.net google drive api v3 OAuth 2.0 received verification code received

VB.NET Google Drive Api v3 OAuth2 vs Service Account

Authentication is necessary if you want to access Google Drive API. There are 2 types of Authentications:
  1. OAuth2 : Will allow you to access another users data, 
  2. Service Account : Can be set up to access your own data.

VB.NET Google Drive Api v3 QuickStart dotnet example source code


VB.NET Google Drive API TroubleShooting

Error : 

VB.NET Google Drive API Error (At least one client secrets (Installed or Web) should be set)

Diagnostic :

You are getting this error because you are trying to use UserCredential instead of GoogleCredential. In the Quick Start Example for Google Drive API Dotnet :

Solution :

VB.NET

Dim Credential As UserCredential

C#

UserCredential credential;

Change the above code to :

VB.NET

Dim Credential as GoogleCredential

C#

GoogleCredential Credential;


Password : projectzone.co
Github repo for the Google Drive Api v3 QuickStart dotnet example for Visual Basic from here

Link to this post

https://adonetaccess2003.blogspot.com/2019/09/vb-net-google-drive-api-source-code.html

Update


  • I have found and converted to VB.NET, the C# Resumable Upload for large files uploading.
  • I've uploaded an example VB.NET Source code on uploading large files to Google Drive using the v3 Api.


Password : projectzone.co

Popular posts from this blog

Visual Basic Online Courses DataGridView Add Edit Delete

Image
VB .NET DataGridView Add Edit Delete Manipulate DataGridView from Visual Basic 2010 with SQL Server Visual Basic Online Course - DataGridView SQL Server Database Note : if you dunno how to work SqlServer With VB.Net : You need to see  this  then  this Logic Using DataGridView Control In VB.Net to Add New - Edit - Delete from/to Sql Server Database or MS-Access or any other Database type. You will find in the end of the lessons the project to download along with source code .  Design 1) Create a new Visual Basic project (Windows Application) name it as (MyDg1) and save it to your hard drive. 2) Place a DataGridView Control on the Form1. 3) Create Sql Server Database file, name it (MyDB) 4) Create Table, name it (Kinds) with just one record, name it (Kinds) 5) Rename the DataGridView Control's name From (DataGridView1) to (DG1) 6) Save/Build the project . 7) Now you have : A project such as this one in the 3 photos (from inside VB.Net and
Continue Reading >>

VB .NET WebView2 WinForms tips

Image
VB .NET WebView2 WinForms Tips Edge WebView2 Tips Edge WebView2 Intro This course blog discusses dealing with Microsoft Edge WebView2 Control. If you are a developer then I'm sure you have searched before for an alternative WebBrowser Control, especially if you are a Desktop Apps Developer. Edge WebView2 Control by Microsoft gives you the ability to Embed Web Technologies like (HTML, CSS, JavaScript, …, etc.) in your App. It uses rendering engine Microsoft Edge (Chromium), so you can Display the web contents in your Apps. Requirements In order to start Microsoft Edge WebView2 for Desktop Projects as alternative for WebBrowser Control, you need the following : Microsoft Windows (In my case, it is Win10 64bit) Microsoft Visual Studio (In my case, it is VS2017) WebView2 Runtime or any Microsoft Edge (Chromium) non-stable channel installed on supported OS (currently Windows 10, Windows 8.1, and Windows 7). (In my case, Win10 64bit and Microsoft Edge (Chromium)
Continue Reading >>

VB NET Check internet connection

Image
 Check Internet Connection using VB 2010 Using VB.NET to check Internet Connection status This is a very simple example of how to check if there is an internet connection available for your machine (LapTop, PC) using VB 2010 Programming Language . - Project Design : 1) Create new project, (save it) 2) Create new Windows Application form (Form1) 3) Place a Label (Label1) and Timer (Timer1) on your Form (Form1). VB.NET Check Internet Connection - Coding In the following VB.NET Code I'm using two Functions to ( Boolean ) : Check internet connection using  Computer.Network.Ping( "google.com" ) Check internet connection Using stream = client.OpenRead( "http://www.google.com" ) ♥ Here are some online Visual Basic lessons and courses : Visual Basic .Net snippets collection Visual Basic .Net - How to check for the internet connection Visual Basic .Net - POP3 and Receiving E-mails Visual Basic .Net - Generate Random Combi
Continue Reading >>

Visual Basic 2010 Working With DataBase Full Project Example

Image
VB 2010 Book Working With Database Full Project Example Download VB 2010 Book to work with MS-Access Book Link via MediaFire.com The book is 5 chapters and is explained here, it contains source code of a project example on how to work with Microsoft Access Database from Visual Basic 2010 .     In the book; the photos show how to start your project, how to select your database and how to display it. Here, we'll discuss each photo and explain each code block. Chapter#1 - Released VB .Net 2010 Working With DataBase Full Project Example     Photo (1) : Shows the folder that contains the project, the (My-First-Con.vbproj) is the icon you need to click to open the project.     Photo (2) : From menu (Data) choose ( Add New Data Source ), a popup dialog-box will show titled (Choose a Data Source Type) and you select (Database) as long as we are connecting to one, then click next.     Photo (3) : A popup dialog-box appears titled (Data Source Configuration) an
Continue Reading >>

Visual Basic 2010 Math Functions

Image
Microsoft Visual Basic 2010 Math Functions Visual Basic 2010 Math functions Math and String Functions In addition to performing simple arithmetic and string operations with the arithmetic and string operators, Visual Basic programs can take advantage of several built-in  mathematical functions  and  string functions to perform useful processing that, otherwise, could require highly complex original code. Mathematical Functions Popular mathematical functions are summarized in the following table. Note that certain functions do  not  require the  Math.  prefix. Function Use Math.Abs() Returns the absolute value. Math.Abs(-10)  returns  10 . Math.Ceiling() Returns an integer that is greater than or equal to a number. Math.Ceiling(5.333)  returns  6 . Fix() Returns the integer portion of a number. Fix(5.3333)  returns  5 . Math.Floor() Returns an integer that is less
Continue Reading >>