User Profile

Collapse

Profile Sidebar

Collapse
quintonmartin
quintonmartin
Last Activity: Dec 16 '09, 10:43 PM
Joined: Nov 24 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • quintonmartin
    replied to problem updating table with varbinary(max) field from xml
    in C Sharp
    problem updating table with varbinary(max) field from xml

    Ok, I figured out what's going on.

    byte[] testing = Convert.FromBas e64String("AA== ");
    //testing is now a 1 byte array with a zero.

    So, GetXml() is converting the binary data to base64 automatically.

    However, in SQL Server, this base64 string is getting encoded AGAIN.

    At the bottom of the page at this...
    See more | Go to post

      Leave a comment:

    • quintonmartin
      started a topic problem updating table with varbinary(max) field from xml
      in C Sharp

      problem updating table with varbinary(max) field from xml

      Here's my problem.

      I have a client application that uses a web service for data access. I can read/update many records in many tables, however, I am not getting what I expect for a varbinary(max) field I am trying to update.

      Here's how I'm doing it.

      I have a strongly typed dataset in c#. The column in question is defined as

      System.Byte[] LogoImage,

      for a simple test,...
      See more | Go to post
      No activity results to display
      Show More
      Working...