SQL byte[] Parameters

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) : http://stackoverflow.com/questions/1955977/insert-binary-data-into-sql-from-c-sharp-without-a-stored-procedure — Mzf, May 23 '13 at 18:14
Ha. Now that it's closed - SO doesn't allow me to delete my question. — ispiro, May 23 '13 at 18:19
@cvraman I don't know. Maybe when a post gets closed as a duplicate, they remove the original suggestion for it? (Though I don't think so.) — ispiro, May 23 '13 at 18:56

score 0 · Answer 1 · answered May 23 '13 at 18:14

0

You can use paramete datatype VarBinary

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

answered May 23 '13 at 18:14

SQL byte[] Parameters

1 Answers1