C# Create byte array in code from copied SQL value?

Question

I stored a file in SQL server as a byte array. However, I want that file to be a default value when I initialize the database. The initialization is done in code (inserting some fixed values etc). If I look into SQL server I see the file's value, something like 0x89504E4...... How can I set a C# property (byte[]) to this value? MyObject.filebytes = 0x89504E4...... obviously won't work.

Thanks

Please look at [this question](http://stackoverflow.com/questions/311165/how-do-you-convert-byte-array-to-hexadecimal-string-and-vice-versa) and its answers. — John Willemse, Jul 03 '14 at 13:25

score 2 · Accepted Answer · answered Jul 03 '14 at 13:25

2

You can include your default file in project and then set value of your object with it's contents, like

MyObject.filebytes = File.ReadAllBytes("default.bin");

answered Jul 03 '14 at 13:25

Encarmine

453
3
13

Thats not really what I meant, but it will do :) – NeedACar Jul 03 '14 at 15:57

score 0 · Answer 2 · answered Jul 03 '14 at 13:23

0

If I understand your question correctly, you could create property inside that class that is array of bytes, then you could read the file from wherever you please be it file or database.

public class MyObject
{
    public byte[] File { get; set; }
}

answered Jul 03 '14 at 13:23

Matas Vaitkevicius

58,075
31
238
265

score 0 · Answer 3 · answered Jul 03 '14 at 13:25

0

Close enough. You can either load it from an embedded resource or a file, or if it's just a short string, you could use the array initializer syntax:

MyObject.FileBytes = new byte[] { 0x89, 0x50, 0x4E, ... };

answered Jul 03 '14 at 13:25

Luaan

62,244
7
97
116

loopedcode · Answer 4 · 2014-07-03T13:40:36.377

Assuming you are attempting to load byte array off sql server returned result set you can do the following. For example, if you get a SqlDataReader back from ExecuteReader call on sql command "SELECT mybytecolumn from mytable":

public byte[] GetBytes(SqlDataReader reader)
{
 const int MAXBUFFER = 4096;
 byte[] buffer = new byte[MAXBUFFER]
 using(MemoryStream ms = new MemoryStream())
 {
   int start = 0;
   long length;
   do
   {
      // Following is assuming column 0 has the byte data on the returned result set
      length = reader.GetBytes(0, start, buffer, 0, MAXBUFFER);
      ms.Write(buffer, 0, (int)length);
   }
   while(length == MAXBUFFER);
   return ms.ToArray();
 }
}

score 0 · Answer 5 · answered Oct 18 '22 at 22:14

Pass copied value from database to GetBinaryFromHexaString function and it will return the string data.

public static string GetBinaryFromHexaString (string hexa)
{
    byte[] data = null;
    string retData = string.Empty;
    List<byte> bList = new List<byte>();
    try {
        for (int i = 2; i < hexa.Length - 1; i+=2) {
            string hStr = hexa.Substring(i, 2);
            byte b = byte.Parse(hStr, NumberStyles.HexNumber, CultureInfo.InvariantCulture);
            bList.Add (b);
        }
        data = bList.ToArray();
        retData = System.Text.Encoding.UTF8.GetString(data);
    }
    catch {}
    return retData;
}

Reference: Convert string to System.Data.SqlTypes.SqlBytes C#

C# Create byte array in code from copied SQL value?

5 Answers5