Re: Using C# to insert blob into Oracle

From: Nicholas Paldino [.NET/C# MVP] (mvp_at_spam.guard.caspershouse.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 12:44:00 -0500

Chris,

    Yes, it is just text, but you want a byte array from it? There are many
ways to convert text to a byte array. Is the text representative of a
binary value, or is it actual text, and you want to store it in a binary
form in the table? 

-- 
               - Nicholas Paldino [.NET/C# MVP]
               - mvp@spam.guard.caspershouse.com
"Chris Fink" <chris.fink@gmail.com> wrote in message 
news:%23411OXYKFHA.1308@TK2MSFTNGP15.phx.gbl...
> The string is just text.
>
> "Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> wrote 
> in
> message news:%239u6F9XKFHA.1620@TK2MSFTNGP14.phx.gbl...
>> Chris,
>>
>>     It depends on the format of the string.  Is it in hex, or is it 
>> base64
>> encoded, or something else?
>>
>>
>> -- 
>>                - Nicholas Paldino [.NET/C# MVP]
>>                - mvp@spam.guard.caspershouse.com
>>
>> "Chris Fink" <chris.fink@gmail.com> wrote in message
>> news:%23sTII2XKFHA.3512@TK2MSFTNGP15.phx.gbl...
>> > How do I convert a C# string into a byte array?  Which class do I use,
> the
>> > StreamReader, StringReader, etc?  Any sample code is appreciated!
>> >
>> > "Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> 
>> > wrote
>> > in
>> > message news:eTasBpXKFHA.3336@TK2MSFTNGP10.phx.gbl...
>> >> Chris,
>> >>
>> >>     The provider for Oracle should represent the field as a byte 
>> >> array.
>> > You
>> >> should be able to assign a new byte array to this field in a data set,
>> >> and
>> >> then update the field through an ad-hoc query or stored procedure, 
>> >> just
>> > like
>> >> you would any other value in the database.
>> >>
>> >>     Hope this helps.
>> >>
>> >>
>> >> -- 
>> >>                - Nicholas Paldino [.NET/C# MVP]
>> >>                - mvp@spam.guard.caspershouse.com
>> >>
>> >> "Chris Fink" <chris.fink@gmail.com> wrote in message
>> >> news:OoGdgjXKFHA.3340@TK2MSFTNGP14.phx.gbl...
>> >> >I have setup an Oracle table which contains a blob field.  How do I
>> > insert
>> >> > data into this field using C# and ADO.net?
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Help in French|Spanish|German translation.
    ... I am also an author of User-defined string functions. ... WORDTRANEX (cSearched, cArExpressionSought | cExpressionSough, ... each string of the array is searched ... If the parameter nArStartOccurrence is -1 or omitted, the replacement starts ...
    (microsoft.public.fox.helpwanted)
  • Re: passing a string to a dll
    ... Joe, I really appreciate you taking the time to demonstrate this. ... sure how I would implement indexing it for random alphanumeric codes. ... I might handle the array. ... I actually have been wondering if I could use a second string ...
    (microsoft.public.vc.mfc)
  • Re: passing a string to a dll
    ... I might handle the array. ... I actually have been wondering if I could use a second string ... look at insertion cost, organization cost, and search cost. ...
    (microsoft.public.vc.mfc)
  • Re: Array Type Mismatch
    ... Dim resultAs String ... I am still somewhat confused as to why nothing is stored in the array. ... Public Function TextBoxGetLine(....arguments... ...
    (microsoft.public.access.formscoding)
  • Re: NumberFormatException:please help me......!!!
    ... Record that has string and array of double as members) and file could ... follows it on a line of the input file, you could use the String as a key to ... contain String representations of doubles. ...
    (comp.lang.java.programmer)