string sql = "SELECT CMD_PARAM FROM TBL_FKCMD_TRANS_CMD_PARAM WHERE trans_id='" + asTransId + "' And device_id='" + asDevId + "'";
OracleCommand comText = new OracleCommand(sql, sqlConn);//创建Command对象
OracleDataReader dr;//创建DataReader对象
dr = comText.ExecuteReader();//执行查询
while (dr.Read())
{
Byte[] blob = new Byte[(dr.GetBytes(0, 0, null, 0, int.MaxValue))];
dr.GetBytes(0, 0, blob, 0, blob.Length);//BLOB转换成byte[]
//String Str = Encoding.Unicode.GetString(blob);//byte[]转成 string
abytCmdParamBin = blob;
}
C#中,Oracle的BLOB类型转成byte[]
最新推荐文章于 2021-08-16 23:21:13 发布