Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Save Image of QGraphicview in SqlServer

Save Image of QGraphicview in SqlServer

Scheduled Pinned Locked Moved Unsolved General and Desktop
sqlserverqt 5.4imagesaving
11 Posts 3 Posters 3.9k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    M4RZB4Ni
    wrote on 11 Aug 2016, 18:48 last edited by
    #1

    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?

    Thanks
    M4RZB4Ni

    1 Reply Last reply
    0
    • S Offline
      S Offline
      SGaist
      Lifetime Qt Champion
      wrote on 11 Aug 2016, 21:55 last edited by
      #2

      Hi,

      Are using a QGraphicsPixmapItem ?

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0
      • M Offline
        M Offline
        M4RZB4Ni
        wrote on 14 Aug 2016, 16:51 last edited by
        #3

        no
        and my field Type in date base in IMAGE

        Thanks
        M4RZB4Ni

        M 1 Reply Last reply 14 Aug 2016, 18:31
        0
        • M M4RZB4Ni
          14 Aug 2016, 16:51

          no
          and my field Type in date base in IMAGE

          M Offline
          M Offline
          mrjj
          Lifetime Qt Champion
          wrote on 14 Aug 2016, 18:31 last edited by mrjj
          #4

          @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).

          M 1 Reply Last reply 14 Aug 2016, 19:21
          0
          • M mrjj
            14 Aug 2016, 18:31

            @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).

            M Offline
            M Offline
            M4RZB4Ni
            wrote on 14 Aug 2016, 19:21 last edited by
            #5

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

            Thanks
            M4RZB4Ni

            M 1 Reply Last reply 14 Aug 2016, 19:58
            0
            • M M4RZB4Ni
              14 Aug 2016, 19:21

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

              M Offline
              M Offline
              mrjj
              Lifetime Qt Champion
              wrote on 14 Aug 2016, 19:58 last edited by mrjj
              #6

              @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. :)

              M 1 Reply Last reply 14 Aug 2016, 20:07
              0
              • M mrjj
                14 Aug 2016, 19:58

                @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. :)

                M Offline
                M Offline
                M4RZB4Ni
                wrote on 14 Aug 2016, 20:07 last edited by
                #7

                @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

                Thanks
                M4RZB4Ni

                M 1 Reply Last reply 14 Aug 2016, 20:10
                0
                • M M4RZB4Ni
                  14 Aug 2016, 20:07

                  @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

                  M Offline
                  M Offline
                  mrjj
                  Lifetime Qt Champion
                  wrote on 14 Aug 2016, 20:10 last edited by
                  #8

                  @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.

                  M 1 Reply Last reply 14 Aug 2016, 20:38
                  0
                  • S Offline
                    S Offline
                    SGaist
                    Lifetime Qt Champion
                    wrote on 14 Aug 2016, 20:37 last edited by
                    #9

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

                    Interested in AI ? www.idiap.ch
                    Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

                    1 Reply Last reply
                    1
                    • M mrjj
                      14 Aug 2016, 20:10

                      @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.

                      M Offline
                      M Offline
                      M4RZB4Ni
                      wrote on 14 Aug 2016, 20:38 last edited by
                      #10

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

                      Thanks
                      M4RZB4Ni

                      M 1 Reply Last reply 14 Aug 2016, 20:41
                      0
                      • M M4RZB4Ni
                        14 Aug 2016, 20:38

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

                        M Offline
                        M Offline
                        mrjj
                        Lifetime Qt Champion
                        wrote on 14 Aug 2016, 20:41 last edited by
                        #11

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

                        1 Reply Last reply
                        0

                        1/11

                        11 Aug 2016, 18:48

                        • Login

                        • Login or register to search.
                        1 out of 11
                        • First post
                          1/11
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • Users
                        • Groups
                        • Search
                        • Get Qt Extensions
                        • Unsolved