VB 2010 with MS Access 2010 Error Conversion from type 'DBNull' to type 'String' is not valid.

VB .NET Error Conversion from type 'DBNull' to type 'String' is not valid.

vb.net Error Conversion from type 'DBNull' to type 'String' is not valid.
VB .NET Conversion from type 'DBNull' to type 'String' is not valid.

Error :

Conversion from type 'DBNull' to type 'String' is not valid.

Cause :

Trying to Fetch Data From empty database table field, where database table field doesn't have any data 'null'.

Solution :


According to StackOverFlow, you may also try this solution instead, which also work fine but you need to determine at which end your problem exists "The application" or "The Database table", because you can workaround your this problem "DBNull" from Database table or from Visual Basic .Net.

♥ Here are some online Visual Basic lessons and courses :

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 Google Drive Api Source Code Example

Image
CodeProject 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 How to use Google Developer Console to create a project. How to Configuring Google Api Console How to Install Google Drive Api v3 from Visual Studio 2015 How to Upload Simple file to Google Drive using Google Drive Api v3 from VB.NET How to Upload Large Files (Resumable Upload) using Google Drive Api v3 from VB.NET Async programming. Project desc
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 >>