Store byte array into SQL Server

[Opa1]

Hi,

This question has been asked b4 on these newsgroups. I can't find a
clear example.

I have a byte array called signature. I'd like to store this byte
array in a SQL server varbinary column and then read it back again. I
have the following code snippet:

Assumptions: sqlCon is a valid SQL connection initialized elsewhere

public void InsertSalesTransaction(string SalesPersonID, byte[]
signature)
{

string sCmd = "INSERT INTO SalesTransactions ";
sCmd += "(SalespersonID,Signature)";
sCmd += " VALUES ('" + SalesPersonID + "'," + ???)

SqlCommand sqlCmd = new SqlCommand (sCmd, sqlCon);
sqlCmd.ExecuteNonQuery() > 0;

}
HOW do you insert the signature byte array?

Can someone provide me with an example?

Thanks a lot

[Jon Skeet [C# MVP]]

Opa1 <op***********@yahoo.com> wrote:

This question has been asked b4 on these newsgroups. I can't find a
clear example.

I have a byte array called signature. I'd like to store this byte
array in a SQL server varbinary column and then read it back again. I
have the following code snippet:

Assumptions: sqlCon is a valid SQL connection initialized elsewhere

public void InsertSalesTransaction(string SalesPersonID, byte[]
signature)
{

string sCmd = "INSERT INTO SalesTransactions ";
sCmd += "(SalespersonID,Signature)";
sCmd += " VALUES ('" + SalesPersonID + "'," + ???)

SqlCommand sqlCmd = new SqlCommand (sCmd, sqlCon);
sqlCmd.ExecuteNonQuery() > 0;

}

HOW do you insert the signature byte array?

Use a SqlParameter with a DbType of Binary, and set the value to your
byte array.

You should use parameters for the sales person ID too, ideally - that
will cope if somehow you end up with a quote in the ID, for instance.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too