How to insert a byte array into sql server?

  • Thread starter Thread starter Prince
  • Start date Start date
P

Prince

Hi all,

Can anybody tell how to insert a byte array into sql server...

Looking forward for ur reply...
 
if you use stored procedure, simply add a parameter similar to :
SqlParameter param = new SqlParameter("@MyBinaryColumn", SqlDbType.Binary);
param.Value = ary;

or if you use dynamic sql / embedded sql string, parameterize your sql
string like:

"insert into MyTable(MyBinaryColumn) values(@MyBinaryColumn"

then add parameter same as you do with stored procedures.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert a byte array into sql server? 1
How array allocation is implemented in c#? 1
Store byte array into SQL Server 1
Insert Byte array to SQL Server using string 7
comparing byte arrays 4
How to I assign some bytes in hex to a byte array 6
read binary file to a byte array 11
copy byte array 2

Back
Top