C# Stored Procedure Processing Binary Data To Sql Fields

In the code sample below, case eLABEL, eENGUNITS works ok. The target SQL field is defined as varchar(50).

The second section is not so happy. It is attempting to write to an SQL field defined as binary(2)



Executing an SQL script to excercise this line results in error:


System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'foreign'

where 'foreign' is the name (FieldDef.sFldName) of the SQL field being written.



The c# code composes the following command:



"UPDATE " + acPointType + " SET " + FieldDef.sFldName +

" = @data_params WHERE VEC = '" + acVECName +

"' and name = '" + acPointName + "';";
What is the proper syntax for the second case set?






Code Snippet

case vcidatatype.eLABEL:

case vcidatatype.eENGUNITS:

{


byte[] bbuff = new byte[512];

bbuff = rdr.ReadBytes(FieldDef.iLen);

vciSqlCommand.Parameters.Add(new SqlParameter("@data_params", SqlDbType.VarBinary));

vciSqlCommand.Parameters["@data_params"].Value = bbuff;

break;

}

case vcidatatype.eFIDADR:

case vcidatatype.eLANADR:

{


byte[] bbuf = new byte[512] ;

bbuf = rdr.ReadBytes(2);

vciSqlCommand.Parameters.Add(new SqlParameter("@data_params", SqlDbType.Binary));

vciSqlCommand.Parameters["@data_params"].Value = bbuf;

break;
}