Save Image of QGraphicview in SqlServer

M4RZB4Ni

Hello,
i Have a QgraphicView
and with scene i set a image in this
and with brush image will edit
now i want to
Save and Retrieve Edited Image in SqlServer Database with "Image" Field
How i can do this?

SGaist

Hi,

Are using a QGraphicsPixmapItem ?

M4RZB4Ni

no
and my field Type in date base in IMAGE

mrjj

@M4RZB4Ni

hi
maybe this is interesting
https://wiki.qt.io/How_to_Store_and_Retrieve_Image_on_SQLite
Its using BLOBS.

I dont know what IMAGE does a field type.
If its a MS SQL server, i think you should look into
VarBinary(max).

M4RZB4Ni

@mrjj
thanks
But IMAGE DataType is a New DataType in Sql Server 2014

mrjj

@M4RZB4Ni said:

IMAGE DataType

Ok, i must have misunderstood
https://msdn.microsoft.com/en-us/library/ms187993.aspx
"
IMPORTANT! ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead."

Regardless, its still just a BLOB and the example should work also. :)

M4RZB4Ni

@mrjj
Thank You So Much
i have one Other Question
if i have to Select or Insert on a Sql Server Database
and this Database Placed on Other Computer on Network(server)
if i just change the Server Name in my Connection enough?
Thanks so much again

mrjj

@M4RZB4Ni
Hi
If client pc (your program) and the the database server is on same local lan then
YES, should not matter in most networks.

SGaist

Depending on your other server setup, you might also have to change the credentials.

M4RZB4Ni

@mrjj
no
My program on Client Pc
and Database on Other Pc(Server)

mrjj

@M4RZB4Ni
yes, the big question is if they are on same lan/network. :)