How can I manually generate a SQL statement (SQLCommand) containing binary
data ?
I'd like to write all the text of the SQL statement for that operation...
Example :
I Have Binary data (that represent an image)
Byte[] TmpByte;
TmpByte = ....BINARY DATA OF AN IMAGE....
Now I want to generate the SQL statement
to insert the content of TmpByte into
MYTABLE ( MyIndex = VARCHAR(25) / MyData = VARBINARY (1000) )
Something like that :
INSERT MYTABLE (MyIndex, MyData) VALUES ('Index 1', ???? )
But I don't know how to put in place of the ????
I was expecting that someting like '01010101....101001' could work but it
didn't.
Thank for any help !
Steph.