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]]

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.