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 Offline
    P Offline
    Pankaj Garg
    wrote on last edited by
    #1

    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 J S O 7 6 Replies 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
      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