How Do I Insert a Byte[] Into an SQL Server VARBINARY Column

Question

I have a byte array highlighted below, how do I insert it into a SQL Server database Varbinary column?

byte[] arraytoinsert = new byte[10]{0,1,2,3,4,5,6,7,8,9};  string sql =      string.format     (     "INSERT INTO mssqltable (varbinarycolumn) VALUES ({0});",WHATTODOHERE     ); 

Answer 1

Try this:

"0x" + BitConverter.ToString(arraytoinsert).Replace("-", "") 

Although you should really be using a parameterised query rather than string concatenation of course...