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 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 d...
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 >>

VB .NET DropBox Api Source Code Example

Image
VB .NET DropBox Api Example Create a Desktop Application using VB .NET and Dropbox Api VB .NET Dropbox Api Example Requirements Visual Basic 2010 [recommended VS 2015] or above (Visual Studio 2019) from here Visual Basic previous Example from here Dropbox Account from here .NET Framework 4.0 or above for above VS versions. Dropbox Api for current .NET Framework version of yours 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 Project description I will use the VB.NET example from previous post to add a functionality to it. I will add Backup Database to Dropbox [ToolStripMenuItem] VB.NET Dropbox Database file Backup When a user press [ToolStripMenuItem -> Backup to Dropbox] : The VB.NET application does the following : Checks for Internet Connection Status. Connects to Dropbox Appli...
Continue Reading >>

Visual Basic .Net - Button Sound / Music Play

Image
Visual Basic 2010 - Button Sound Visual Basic 2010 - Play sound on buttons The code is simply goes like this You can copy and paste in your (Click_Event) or whatever it is you wish (MouseClick - MouseHover - MouseLeave) : Dim  MySound  As   New  System.Media.SoundPlayer()     MySound.SoundLocation =  "path to the .Wav file" MySound.Load() MySound.Play() ' OR you can use this : Sub PlaySystemSound() My.Computer.Audio.PlaySystemSound( System.Media.SystemSounds.Asterisk)   End Sub Background playing   It lets the application execute other code while the sound plays. The My.Computer.Audio.Play method allows the application to play only one background sound at a time; when the application plays a new background ...
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 >>

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 don't know how to work SQL Server 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 ph...
Continue Reading >>