//
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);
// 去掉后边补齐的