Photo not saving in database

[callraheel]

' getphoto will return the array of bytes of images

Dim photo() As Byte = GetPhoto()
myCommand.CommandText = "INSERT INTO photos(PhotoID,PhotoSize,Photo) VALUES(@PhotoID,@PhotoSize,@Photo);"

myCommand.Parameters.Add("@PhotoID", MySqlDbType.VarChar).Value = txtSID.Text

myCommand.Parameters.Add("@PhotoSize", MySqlDbType.Double).Value = _GetPhotoLength()

myCommand.Parameters.Add("@Photo", MySqlDbType.LongBlob).Value = photo

myCommand.ExecuteNonQuery()

And the error is as follows
MySql.Data.MySqlClient.MySqlException: #23000Column 'PhotoID' cannot be null


The procedure of adding photo like this is found in .NET Framework 1.1 documentation and in an example.

Anyhelp will be appreciated
Regards

 

[kulrom]

it's probably because of @PhotoID paramater ... actually somehow it doesn't pass content from txtSID.Text or txtSID.Text is an Empty String. Check txtSID.Text before add to the parameter ... you may do that very simple by MessageBox i.e. MessageBox.Show(txtSID.Text)


Cheers

 

[callraheel]

Well Kulrom i did that too, but the txtSID.text contains text, its not empty..........

and still there is same error

 

[kulrom]

Is this field (@PhotoID) of number datatype and does certain field has Primary key ...?


Cheers


Ah ... btw, you asked me about how to subscribe again to certain thread. Well, to subscribe to certain thread follow this ... Thread Tools --> Subscribe to this thread

 

[callraheel]

Yes it is primary key and its datatype is varchar and length 25..But i insert in it always unique value!

 

[kulrom]

myCommand.CommandText = "INSERT INTO photos(PhotoID,PhotoSize,Photo) VALUES(@PhotoID,@PhotoSize,@Photo);"

what is this for? semicolon shouldn't be there ... i guess

Cheers

 

[kulrom]

However, you have dbNull field or you wouldn't get the error ... do you have a try catch statement there?

Cheers

Added: Actually i think you should change the way how you add the parameters .... give it a try to add parameters as it follows:

 myCommand.Parameters.Add("?PhotoID", txtSID.Text)

don't use "@" for mySQL's parameters

 

[callraheel]

Well Great Man.. Its solved Now
Thankyou very much.
Cheers!!!

 

[kulrom]

Btw, what was the solution ... parameters or semicolon?

Cheers

 

[callraheel]

Well kulrom, problem was parameters, semicolon has not any problem. if used then its good otherwise no problem.

So i used the all parameteras followed by (?) and problem solved.
Well Great Work!
Cheers....

 

[kulrom]

Ok i see ... btw, you are welcome


Cheers