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 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 photos (from insid
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 >>

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 .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 sound, it stops playing the previous background sound. You c
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 >>