软讯网络 > 编程语言 > .NET > C#.NET > 从数据库中取出IMAGE字段并返回DataSet
【标 题】：从数据库中取出IMAGE字段并返回DataSet
【关键字】：
IMAGE,DataSet
【来 源】：http://blog.csdn.net/hufengwen/archive/2006/11/24/1412526.aspx
从数据库中取出IMAGE字段并返回DataSet
从数据库中取出IMAGE字段并返回DataSet:
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DatabaseFactory.CreateDatabase("BASDatabase");
Microsoft.Practices.EnterpriseLibrary.Data.DBCommandWrapper records = db.GetStoredProcCommandWrapper("getActionInfor");
records.AddInParameter("alertMessageID",DbType.Int32,alertMessageID);
System.Data.IDataReader ds2 = db.ExecuteReader(records);
ds2.Read();
byte[] result = (byte[])ds2["XMLData"];
System.IO.MemoryStream ms = new MemoryStream(result);
System.Data.DataSet ds = new DataSet();
ds.ReadXml(ms);ds2.Close();
DataSet allrecords = db.ExecuteDataSet(records);
return ds;
|