Getting an Exception! Any Help

Hot Topic

Hello from a returning learner...
Mdi bug?
typedef arrangement CL doesn't like
rand() --- its ALWAYS 41!!!!
How do I create a Northwind db connection string ?
Add date in a database; C#
VB2005 don't view SQL SERVER EXPRESS
BindingSource.Filter Problem Part 2
how to save usersettings
How to close Explorer.EXE and restart at END

VS Express Editions

Can Visual Studio 2005 express be used to create Win32 applications or for future .net versions?
C# Absolute Beginner Project Files arent available for Final Project!
How do I make a windows form that can be dragged over the screen without title bar?
prob using afxdisp.h /MFC use/ CLR support
Issue with image.FromFile...
Read a text from a file that is located on an externel location (website)
win 32 console application
IIS with VisualWebDeveloper
msvcp80d.dll debug problem
URL Browser

Getting an Exception! Any Help

I am running the following code to pull an image from my SQL Database. The image is a pointer to a file in a directory. I get the following exception "Conversion from type "DBNull" to type "String" is not valid. The highlighted line is where it throws the exception. Any help would greatly appreciated. Thanks.

Dim MyReader As OleDb.OleDbDataReader

Dim MyCommand As New OleDb.OleDbCommand("SELECT Name, Image FROM dbo.Info")

Dim MyConnection As New OleDb.OleDbConnection("Provider=SQLOLEDB;server=(local)\SQLExpress;Integrated Security=SSPI;database=dbOne")

MyConnection.Open()

MyCommand.Connection = MyConnection

MyReader = MyCommand.ExecuteReader

MyReader.Read()

Me.PictureBox1.Image = Image.FromFile(MyReader("Image"))

MyConnection.Close()

Answer this question

Getting an Exception! Any Help

  • Dave Sundell

    You have to convert the binary data to a memory stream and then create a bitmap. There is an example on the vb-tips website.


  • beatriz_da

    I am having all sorts of trouble trying to modify this to get it to work. Everything I try causes issues. Is there an easier way or do I just need to tinker until I get it to work
  • Getting an Exception! Any Help
Answer this question