CrystalReport 水晶报表动态查询显示图片问题,急!
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> CrystalC# oracle图片显示 --------------------编程问答-------------------- 没做过啊,不过直接看你这个<xs:element name="IMG" type="xs:base64Binary" minOccurs="0" />里面的type好像不对,图形的二进制数据怎么会是base64编码的?
补充:.NET技术 , C#