How do I save a Byte Array to a Database in vb.net

Question

I have a byte array of a file and I need to save it into my database in a field that has been set aside of type image.

However I have a problem my data access class takes a sql string and commits it to the database for example.

"EXECUTE stored proc @parm1, @parm2, @parm3"

However the problem is I cannot figure out how to transfer the byte array to string so that I can add it as an argument.

I hope this make sense.

I also understand that I can build parameters in com objects but I do not want to do this as it will disrupt my whole data access class and I am not prepared to do this at the moment.

Thanks for any help.

in what datatype are you trying to store it? I would do it in varbinary and then use Mehrdad's answer. — Shimmy Weitzhandler
– Shimmy Weitzhandler, Commented Oct 27, 2009 at 3:37

Mehrdad Afshari · Accepted Answer · 2009-08-28 16:07:29Z

2

In SQL statements, you can use the hexadecimal notation "0x1323235..." to represent binary data but it's not really a good way to deal with it. You should be using parameters:

sqlCmd.Parameters.AddWithValue("@parameterName", byteArrayInstance)

answered Aug 28, 2009 at 16:07

Mehrdad Afshari

424k93 gold badges864 silver badges796 bronze badges

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

Comments

Gratzy · Accepted Answer · 2009-08-28 16:47:30Z

0

Answering question of how to burn byte array into a string. Convert the byte array to a string

byte[] b = new byte[100];
string s = System.Text.ASCIIEncoding.ASCII.GetString(b);

edited Aug 28, 2009 at 16:47

answered Aug 28, 2009 at 16:12

Gratzy

9,4174 gold badges32 silver badges45 bronze badges

2 Comments

recursive Over a year ago

That is a way to convert a byte array to a string, but it is completely unusable in this context.

Gratzy Over a year ago

The poster's original question was how to turn the byte array into a string because that was what the argument to his data access class was and he specified he didn't want to use parameters.

Collectives™ on Stack Overflow

How do I save a Byte Array to a Database in vb.net

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related