从数据库中取出IMAGE字段并返回DataSet

来源:互联网 发布:床帘 淘宝 编辑:程序博客网 时间:2024/04/29 18:38

从数据库中取出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);
    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;