Manage image in Database from PictureEdit

[Kosal]

Dear Sir/Madam

I using vb,net 2005 with DevExpress 8.2 and i want to insert/delete/update image from PictureEdit to Database by store procedure.

I using code insertUpdate as below but still error

If Crs.GF_RunSQL("EXEC Sp_InsertUpdate_Company @cID = " & Me.lblcID.Text & _
                                     ",@cBName=" & Crs.GF_ToStr(Me.txtBrandName.Text, True) & _
                                     ",@cName=" & Crs.GF_ToStr(Me.txtCompanyName.Text, True) & _
                                     ",@cAddress=" & Crs.GF_ToStr(Me.txtAddress.Text, True) & _
                                     ",@cTel=" & Crs.GF_ToStr(Me.txtTel.Text, True) & _
                                     ",@cFax=" & Crs.GF_ToStr(Me.txtFax.Text, True) & _
                                     ",@cEmail=" & Crs.GF_ToStr(Me.txtEmail.Text, True) & _
                                     ",@cWebsite=" & Crs.GF_ToStr(Me.txtWebsite.Text, True) & _
                                     ",@cBrAcronym=" & Crs.GF_ToStr(Me.txtPrefix.Text, True) & _
                                     ",@cLogo=" & pteLogo.EditValue & _
                                     ",@cUser=" & Crs.GF_ToStr(Crs.gv_strUserName, True) & _
                                     ",@cDate=" & Crs.GF_ToStr(Format(Date.Now, "yyyy-MM-dd hh:mm:ss tt")) & _
                                     ",@cSysID=" & Me.lblSysID.Text) Then
 

how can i do?

please help.

[Frinavale]

Hi Kosal,

I have changed the title of your thread from "Need you help" to something that better reflects the problem that you are trying to solve. In the future please use a better description for your thread title. Also, as a full member, you are expected to use code tags when posting code snippets. This makes it easier to read your question.


Please post any error messages that you are receiving.
Also, please explain what an PictureEdit is/does since I think this might be your own custom control.

-Moderator Frinny

[nukefusion]

@Frinavale
I think can add a little bit of extra info there, as it's one I've used before. The PictureEdit control is a custom control developed by a company called DevExpress. It's like a standard .net picturebox control but allows the user to interact with the picture through editing, etc.

What I didn't understand is exactly the error was you were having - whether it is an SQL error, or an exception elsewhere in your code. I was also a bit lost on what these other functions are that begin with the Crs prefix. Is this a custom class you are using?

If you could post the full text of the exception or error that occurs that would be a good start.

[sashi]

BLOB is the technique you should look into. Run a search on this site, i've wrote an article on BLOB.