Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. insertion of image in sql sever 2000

insertion of image in sql sever 2000

Scheduled Pinned Locked Moved ASP.NET
databasequestion
20 Posts 14 Posters 0 Views 1 Watching
  • 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.
  • P Pankaj Garg

    CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

    J Offline
    J Offline
    janet2008
    wrote on last edited by
    #2

    Do you got any error?

    P 1 Reply Last reply
    0
    • J janet2008

      Do you got any error?

      P Offline
      P Offline
      Pankaj Garg
      wrote on last edited by
      #3

      If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

      P J P CPalliniC 4 Replies Last reply
      0
      • P Pankaj Garg

        If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

        P Offline
        P Offline
        Paddy Boyd
        wrote on last edited by
        #4

        She's not wasting your time - have you tried the code? Does it work? If it doesn't then send us an error and we can help, but we're not going to compile your code for you...

        P 1 Reply Last reply
        0
        • P Paddy Boyd

          She's not wasting your time - have you tried the code? Does it work? If it doesn't then send us an error and we can help, but we're not going to compile your code for you...

          P Offline
          P Offline
          Pankaj Garg
          wrote on last edited by
          #5

          Every thing is provided to u , if u can't sort out even now , then shame on u, Even the stupid or duffer can understand this much elaborated code , and u r talking on behalf of her, ok , Can't u see , the code i provided , is there any thing hidden ? Everything is provided. Instead of making arguments and wasting others time , y don;t u people solve the problem, by the way , we r here to solve others problem or to speak on behalf of others and waste others time.

          R 1 Reply Last reply
          0
          • P Pankaj Garg

            If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

            J Offline
            J Offline
            janet2008
            wrote on last edited by
            #6

            :laugh: :laugh: :laugh:

            P 1 Reply Last reply
            0
            • J janet2008

              :laugh: :laugh: :laugh:

              P Offline
              P Offline
              Pankaj Garg
              wrote on last edited by
              #7

              Seems u need some rest and a doctor to check up ur head.

              J B V J 4 Replies Last reply
              0
              • P Pankaj Garg

                Seems u need some rest and a doctor to check up ur head.

                J Offline
                J Offline
                janet2008
                wrote on last edited by
                #8

                Ok thanks for advice :-D

                1 Reply Last reply
                0
                • P Pankaj Garg

                  CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

                  J Offline
                  J Offline
                  J4amieC
                  wrote on last edited by
                  #9

                  You are rude and arrogant. Had I have go to this thread first I would also have asked "Does it work? Does it generate an error?" to your question of "Is the above code right?" In addition, you seem to think that all the code here is sufficient to answer a question about it - WRONG! the final line of code makes absolutely no sense whatsoever.

                  1 Reply Last reply
                  0
                  • P Pankaj Garg

                    Seems u need some rest and a doctor to check up ur head.

                    B Offline
                    B Offline
                    Blumen
                    wrote on last edited by
                    #10

                    You are bloody arrogant.. and don't use native language here in CP ('duffer' means idiot in Hindi, i suppose). Understand one thing, you've got no right to abuse anyone here in CP forums, if you are frustrated go take it out somewhere else buddy, this is not the place for that. If you can't ask a question properly just go to HELL, don't bring shame to other Indian members in CP. Regards, Blumen

                    1 Reply Last reply
                    0
                    • P Pankaj Garg

                      CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

                      S Offline
                      S Offline
                      soap brain
                      wrote on last edited by
                      #11

                      Maybe I can quote you right back: If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

                      "There's not a man in America who at one time or another hasn't had a secret desire to boot a child in the ass." - W. C. Fields

                      1 Reply Last reply
                      0
                      • P Pankaj Garg

                        If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

                        P Offline
                        P Offline
                        Paul Conrad
                        wrote on last edited by
                        #12

                        pankajgarg wrote:

                        Don't waste mine

                        How about a more descriptive post? What is the problem you are having? If you are rude to people trying to help, then bugger off.

                        "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

                        1 Reply Last reply
                        0
                        • P Pankaj Garg

                          CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

                          O Offline
                          O Offline
                          Oakman
                          wrote on last edited by
                          #13

                          You, sir, are rude, and stupid. Apparently you think that this forum has been set up to do your work for you so yhou can continue to pretend to be a developer. p.s. your code sucks scissors.

                          Jon Information doesn't want to be free. It wants to be sixty-nine cents @ pound.

                          P 1 Reply Last reply
                          0
                          • O Oakman

                            You, sir, are rude, and stupid. Apparently you think that this forum has been set up to do your work for you so yhou can continue to pretend to be a developer. p.s. your code sucks scissors.

                            Jon Information doesn't want to be free. It wants to be sixty-nine cents @ pound.

                            P Offline
                            P Offline
                            Paul Conrad
                            wrote on last edited by
                            #14

                            Oakman wrote:

                            stupid. Apparently you think that this forum has been set up to do your work for you so yhou can continue to pretend to be a developer

                            I agree. Hence, my sig from Pete O'Hanlon

                            "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

                            1 Reply Last reply
                            0
                            • P Pankaj Garg

                              Every thing is provided to u , if u can't sort out even now , then shame on u, Even the stupid or duffer can understand this much elaborated code , and u r talking on behalf of her, ok , Can't u see , the code i provided , is there any thing hidden ? Everything is provided. Instead of making arguments and wasting others time , y don;t u people solve the problem, by the way , we r here to solve others problem or to speak on behalf of others and waste others time.

                              R Offline
                              R Offline
                              Rob Graham
                              wrote on last edited by
                              #15

                              Actually, I see at least two obvious errors, but since you have chosen to be a rude jerk, I'm going to let you find them for yourself.

                              1 Reply Last reply
                              0
                              • P Pankaj Garg

                                If u don;t have any idea , then y the bloody hell u r participating in the thread. Don't waste mine and ur's time if u don;t have any idea .

                                CPalliniC Offline
                                CPalliniC Offline
                                CPallini
                                wrote on last edited by
                                #16

                                Hi, I'm here only to waste a bit of your precious time. Greetings :)

                                If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
                                [my articles]

                                In testa che avete, signor di Ceprano?

                                1 Reply Last reply
                                0
                                • P Pankaj Garg

                                  Seems u need some rest and a doctor to check up ur head.

                                  V Offline
                                  V Offline
                                  Vasudevan Deepak Kumar
                                  wrote on last edited by
                                  #17

                                  pankajgarg wrote:

                                  Seems u need some rest and a doctor to check up ur head.

                                  First you ought to consult a doctor preferably a psychiatrist since you are really suffering from an acute hysteria. :)

                                  Vasudevan Deepak Kumar Personal Homepage
                                  Tech Gossips
                                  A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

                                  1 Reply Last reply
                                  0
                                  • P Pankaj Garg

                                    CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

                                    7 Offline
                                    7 Offline
                                    73Zeppelin
                                    wrote on last edited by
                                    #18

                                    pankajgarg wrote:

                                    The above code is right?

                                    No, it's wrong.


                                    1 Reply Last reply
                                    0
                                    • P Pankaj Garg

                                      Seems u need some rest and a doctor to check up ur head.

                                      J Offline
                                      J Offline
                                      Jorgen Sigvardsson
                                      wrote on last edited by
                                      #19

                                      What's wrong with you, dip shit? If you want help, you don't act rude. You need a bitch slap.

                                      -- Kein Mitleid Für Die Mehrheit

                                      1 Reply Last reply
                                      0
                                      • P Pankaj Garg

                                        CREATE PROCEDURE [dbo].[spa] @a image AS insert into a(a) values(@a) GO table column name = a datatype = image byte[] buffer=new byte[FileUpload1.FileContent.Length]; byte[] b = new byte[FileUpload1.FileContent.Length]; FileUpload1.PostedFile.InputStream.Read(buffer,0,buffer.Length); p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input); The above code is right?

                                        realJSOPR Offline
                                        realJSOPR Offline
                                        realJSOP
                                        wrote on last edited by
                                        #20

                                        No - your variable naming convention ranks right up there with that new $2500 car from India, and you've provided just enough information to annoy everyone else here. I'm participating in this thread because it was pushed into my sphere of observation. Stop being a dick to the other members.

                                        "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                                        -----
                                        "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

                                        1 Reply Last reply
                                        0
                                        Reply
                                        • Reply as topic
                                        Log in to reply
                                        • Oldest to Newest
                                        • Newest to Oldest
                                        • Most Votes


                                        • Login

                                        • Don't have an account? Register

                                        • Login or register to search.
                                        • First post
                                          Last post
                                        0
                                        • Categories
                                        • Recent
                                        • Tags
                                        • Popular
                                        • World
                                        • Users
                                        • Groups