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 :

'adonetaccess2003.blogspot.com
'This method uses connected mode
If IsDBNull(DataReader!Field_Name) Then
TextBox1.Text = ("Anything you wish for now")
Exit Sub
End If
'Another method using disconnected mode 'DataSet'
TextBox1.Text = DataTable.Rows(0)("Field_Name").ToString()
'Another method from Database Table.
Dim SqlStr As String = "select IsNull(Field_Name,'') as Any_Name from Table_Name"
view raw gistfile1.txt hosted with ❤ by GitHub

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

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

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 Asy...
Continue Reading >>

VB.NET Access 2007 Hierarchical TreeView

Image
VB.NET Access 2007 Hierarchical TreeView visual Basic .Net project Hierarchical TreeView VB.NET Hierarchical TreeView  Project requirements VS 2010 / 2015 .Net FrameWork version 4.5 [Properties : Enable -> Make single instance application] Compile option -> Target CPU : x86 MS Access 2007 / 2010 (*.accdb) VB.NET Hierarchical TreeView  Project logic Populate Access 2007 Database Tables with Data from Visual Basic 2015 Form Controls [TextBox] Display or populate TreeView control with Hierarchical Data From Microsoft Access 2007 Database (*.accdb) Display or populate TreeView control (Parents / Child) with search results from Access 2007 and highlight search results. Perform Insert, Update, Search, Delete commands to/from Access 2007 Database from VS 2015 Form Control MenuStrip. VB.NET Hierarchical TreeView Project steps summary Create Microsoft Visual Basic 2015 Project [Desktop Classic] Windows Form Applicat...
Continue Reading >>

VB.NET How to properly close a windows application Form

Image
VB.NET  How to properly close a windows application Form VB.NET How to properly close a windows application Form Requirements Visual Basic .Net (any version) , VB2010 and up recommend .NET FrameWork 4.0 and above recommended How to properly close a windows application Form in VB.NET ? You may close a Form in VB.NET Application [WinForm] by : KeyPress event Before you test this code you need to set the Form Property [KeyPreview] True, from Form Properties Window. The code below will Read Keyboard button [Escape] when clicked and Executes Close() Private Sub MainFrm_KeyPress(sender As Object, e As KeyPressEventArgs) Handles Me.KeyPress         If e.KeyChar = Chr(Keys.Escape) Then             Close()         End If     End Sub Then in the FormClosing() event, we will place a code to display a message [MsgBox] with [Yes, No, Cancel]. If the user clicked [Yes] then it will...
Continue Reading >>

DAO in VB .NET MS ACCESS Database

Image
How to connect Access Database using DAO In VB  .Net vb .net DAO Data Access Object (DAO) According to Microsoft Docs  , Conversion from DAO TO ADO : Versions of the DAO library prior to 3.6 are not provided or supported in Access. Also : ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. DAO is used with Access databases and is supported through Office 2013. DAO 3.6 is the final version, and it is considered obsolete. These classes work with the other application framework classes to give easy access to Data Access Object (DAO) databases, which use the same database engine as Microsoft Visual Basic and Microsoft Access. The DAO classes can also access a wide variety of databases for which Open Database Connectivity (ODBC) drivers are available. Programs that use DAO databases will have at least a CDaoDatabase object and a CDaoRecordset object. DAO 360 d...
Continue Reading >>

Solution - There is already an open DataReader associated with this Command which must be closed first.

Image
OleDB Error There is already an open DataReader associated with this Command which must be closed first. OleDB Error : There is already an open DataReader associated with this Command Problem There is already an open DataReader associated with this Command which must be closed first. Cause Having more than 1 dataReader result set working at the same time . Solution In my solution example, I work with Sql Server 2000 and VB.Net 2005  The VB. Net Example Project can be downloaded at the end of this post It contains (Sql Server 2000 DataBase - VB.Net Project) The example shows how to : Navigate (First Record - Next Record) using ADO Net 2.0 Online-Mode using SqlClient DataReader ... Sql Database Name : Market Sql Database Table : Market.Info Server Name : evry1falls (in order to see the example correctly, you'll have to Import the Database 'Market' into your sql server 2000 Enterprise Manager) Photo1 : Applica...
Continue Reading >>