//2进制方式 取出数据
tring sql ="select cast (AcctName as binary(5000)) from Account where FormID = 70794";
// SqlHelper.ExecuteScalar 直接准换 bytes
//byte[] bytes = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null) as byte[];
SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null);
rdr.Read();
byte[] b = rdr[0] as byte[];
//转换编码格式
string s = Encoding.UTF8.GetString(b);
//去掉后边补齐的
tring sql ="select cast (AcctName as binary(5000)) from Account where FormID = 70794";
// SqlHelper.ExecuteScalar 直接准换 bytes
//byte[] bytes = SqlHelper.ExecuteScalar(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null) as byte[];
SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null);
rdr.Read();
byte[] b = rdr[0] as byte[];
//转换编码格式
string s = Encoding.UTF8.GetString(b);
//去掉后边补齐的