Help w/ Invalid column name

[WhYuLoOkIn]

Having trouble with a simple database command I keep getting the error invalid column name and I cant seem to figure it out. Please help me figure out some possible problems Thanks.

Dim ConnString As String
        ConnString = "Data Source=.\SQLEXPRESS;AttachDbFilename=
C:\inetpub\wwwroot\KiKoGraphics\App_Data\aspnetdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
        Dim sqlConn As New SqlConnection(ConnString)
        Dim sqlCom As New SqlCommand()
        sqlCom.CommandText = "INSERT INTO ImageTable ('DatabaseImage') VALUES ('@Photo')"
        sqlCom.Connection = sqlConn
        sqlCom.Parameters.Add("@Photo", Data.SqlDbType.Image)
        sqlCom.Parameters("@Photo").Value = Content
        sqlConn.Open()
        sqlCom.ExecuteNonQuery()
        sqlConn.Close()

[ericstenson]

Hi - Check the spelling on your SQL database, this is probably the issue. An invalid column name means the column simply doesn't exist as stated.

Also, try a test. What happens when you run the query:

Select DatabaseImage from ImageTable

Best/Eric

P.S. If this helped, give me some points and marked as solved! :-)

[WhYuLoOkIn]

Hey thanks for responding. The spelling is correct thats why I don't understand the error and I ran the query you suggested, I also ran an update query and in both cases the application did not crash (give me and error). What else could it be?

[ericstenson]

Can you please provide the exact exception being thrown?

[ericstenson]

(stacktrace, too)

[WhYuLoOkIn]

Here is the stack trace.

[WhYuLoOkIn]

That didnt work as expected, try this.

[ericstenson]

Ah, get rid of the ' around databaseimage

[ericstenson]

Also, I am pretty sure you need to get rid of the ' around @Photo...

[ericstenson]

I would recommend not storing images into the database, but rather store the relative path of the image in the database. I think you will find this much better.

[jasminvictoria]

"INSERT INTO ImageTable (DatabaseImage) VALUES ('@Photo')"