我从数据库和本地XML文件中获取数据。我使用MySqlReader通过选择查询从数据库中获取数据,使用DataTableReader对象从XML中获取数据。
MySqlReader可以转换字节数组,但是DataTableReader不能转换字节数组。
//following block is working fine
MySqlDataReader mySqlReader = new MySqlDataReader();
mySqlReader = it will get data from database by select query
Employee employee = new Employee();
employee.Image = DevExpress.XtraEditors.Controls.ByteImageConverter.FromByteArray((byte[])mySqlReader["profilePic"]);
//following block is not working. Error : "unable to cast object of type 'System.String' to type 'System.Bytes[]'"
DataTable dtEmployee = new DataTable();
dtEmployee = dataset.Tables[0];
DataTableReader dtReader = dtEmployee.CreateDataReader();
Employee employee = new Employee();
//error throws here
employee.Image = DevExpress.XtraEditors.Controls.ByteImageConverter.FromByteArray((byte[])dtReader["profilePic"]); 有谁能提出解决这个问题的建议吗?
发布于 2015-11-23 04:30:07
您的MySQL表可能具有“ProfilePic”的BLOB类型,因此可以将其转换为字节数组,但是二进制数据是如何存储在XML中的呢?您的错误提示它存储为字符串,可能在Base64中,所以请尝试使用Convert.FromBase64String
employee.Image = DevExpress.XtraEditors.Controls.ByteImageConverter.FromByteArray((byte[])Convert.FromBase64String(dtReader["profilePic"]));如果二进制数据以另一种格式存储,则需要另一个转换器.
https://stackoverflow.com/questions/33863668
复制相似问题