CrystalReport 水晶报表动态查询显示图片问题，急！

代码哥 2013-03-02 09:10:26

CrystalReport 水晶报表动态查询显示图片
ORACLE资料库图片字段栏位类型为 BLOB
我想通过查询后在水晶报表中直接显示出来。使用下面方法，能把图片数据插入ORACLE 但是查询显示不了，请高手指点？？

写入数据库语句：
FileStream fs = File.OpenRead(aimFile + "\\test.JPG");
byte[] imageb = new byte[fs.Length];
fs.Read(imageb, 0, imageb.Length);
fs.Close();
//string sql = " update img_file set img01=@images where img00='1'";
//SqlCommand com3 = new SqlCommand(sql, sc);
//oc.Open();

string sql = " update tc_dvg_file set dvg25=:IMGDATA where dvg00='20130302'";
OracleCommand omd = new OracleCommand(sql,oc );
omd.Parameters.Add(":IMGDATA", OracleType.Blob).Value = imageb;
omd.Connection.Open();
if (omd.Connection.State != ConnectionState.Closed)
try {
omd.ExecuteNonQuery();
}
catch
{
}
finally
{
omd.Connection.Close();
}

查询部分：
string sql2 = "select dvg25 from tc_dvg_file where dvg00='20130302'";
oc.Open();
OracleDataAdapter oda = new OracleDataAdapter(sql2,oc);
oda.Fill(dsora);
MyReport.Load(strPath);
MyReport.SetDataSource(dsora);
this.crystalReportViewer1.ReportSource = MyReport;

XML文档:
<xs:element name="NewDataSet" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="dvg">
<xs:complexType>
<xs:sequence>
<xs:element name="IMG" type="xs:base64Binary" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>

...全文