SQL byte[] Parameters [duplicate]

Question

I want to INSERT a byte array into a table (using C#). I've seen this: SqlParameterCollection.Add but I can't figure out how to use it - it doesn't seem to have a value parameter like AddWithValue does. (Perhaps there's some way to use AddWithValue with byte arrays?)

And the same goes for a SELECT - I want to SELECT a row WHERE ColumnX = MyByteArray. (The column contains binary).

So how is it done?

Possible duplication (there is code example there) : stackoverflow.com/questions/1955977/… — Mzf
– Mzf, Commented May 23, 2013 at 18:14
Ha. Now that it's closed - SO doesn't allow me to delete my question. — ispiro
– ispiro, Commented May 23, 2013 at 18:19

user1193035 · Accepted Answer · 2013-05-23 18:14:30Z

0

You can use paramete datatype VarBinary

Cmd.Parameters.Add("@ArrayValues", SqlDbType.VarBinary, 100).Value = YourArrayList;

answered May 23, 2013 at 18:14

user1193035

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

Collectives™ on Stack Overflow

SQL byte[] Parameters [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related