// 连接数据源的数据库连接
private OleDbConnection conn;
private OleDbCommand cmdOle;
private OleDbTransaction tranconn;
public string GetStringForBLOB(string strSQL,string strColInfo)
{if (conn.State == ConnectionState.Closed)
conn.Open();
cmdOle.CommandText = strSQL;
string strReturn = "";
OleDbDataReader drDataReader = cmdOle.ExecuteReader(CommandBehavior.SequentialAccess);
if (drDataReader.Read())
{
//读取BLOB数据时将其转换回文本类型
byte[] bList = (byte[])drDataReader[strColInfo];
strReturn = System.Text.Encoding.Default.GetString(bList);
}
drDataReader.Close();
return strReturn;
}