从数据库中取出IMAGE字段并返回DataSet:
DataSet ds = new DataSet();
Database db = DatabaseFactory.CreateDatabase("BASDatabase");
DBCommandWrapper records = db.GetStoredProcCommandWrapper("getActionInfor");
records.AddInParameter("alertMessageID",DbType.Int32,alertMessageID);
records.AddInParameter("createTime",DbType.DateTime,createTime);
Database db = DatabaseFactory.CreateDatabase("BASDatabase");
DBCommandWrapper records = db.GetStoredProcCommandWrapper("getActionInfor");
records.AddInParameter("alertMessageID",DbType.Int32,alertMessageID);
records.AddInParameter("createTime",DbType.DateTime,createTime);
IDataReader ds2 = db.ExecuteReader(records);
ds2.Read();
if(ds2["xmldata"] != null)
{
byte[] result = (byte[])ds2["xmldata"];
MemoryStream ms = new MemoryStream(result);
ds.ReadXml(ms);
ds2.Close();
}
return ds;
ds2.Read();
if(ds2["xmldata"] != null)
{
byte[] result = (byte[])ds2["xmldata"];
MemoryStream ms = new MemoryStream(result);
ds.ReadXml(ms);
ds2.Close();
}
return ds;