How to read varbinary of SQL as string in C#?

Question

I have an web application which reads varbinary from SQL as a byte array in code. Basically it does a ExecuteScalar of the column and returns it as a byte array.

I am now doing a mini version of the application as a Windows application. For this, I am trying to skip the DB connection. I am directly inputting the varbinary value from SQL to a RichTextBox and trying to read it as a byte array. However, I do not get the same byte array. What am I doing wrong and how should I proceed ?

How exactly are you entering binary data into a richtextbox? — Rhys Jones
– Rhys Jones, Commented Mar 9, 2015 at 9:45
@Izzy I get the details as an arraylist and Serialize it using BinaryFormatter class. Not sure if I answered your question though. Let me know if you need more info. — Divakar
– Divakar, Commented Mar 9, 2015 at 11:10
@RhysJones I am just copying the varbinary value from DB and pasting it into a textbox string. — Divakar
– Divakar, Commented Mar 9, 2015 at 11:11
possible duplicate of SQL Server converting varbinary to string — Rhys Jones
– Rhys Jones, Commented Mar 9, 2015 at 11:22

Divakar · Accepted Answer · 2015-03-10 13:42:39Z

0

I got it using this piece of code

    string hex = richTextBox1.Text
    int NumberChars = hex.Length;
    byte[] bytes = new byte[NumberChars / 2];
    for (int i = 0; i < NumberChars; i += 2)
    bytes[i / 2] = Convert.ToByte(hex.Substring(i, 2).ToString(), 16);
    return bytes;

answered Mar 10, 2015 at 13:42

Divakar

6722 gold badges7 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read varbinary of SQL as string in C#?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related