pb系统存的图片,用.net获取显示,失败。
pb写的程序将图片存在数据库的longraw类型字段中,使用updateblob staff_idiograph_dict set staff_idiograph =:lb_object where emp_no =:ls_emp_no USING sqlca;
.net程序想获取图片并显示,用了很多种方法,都提示错误。
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection("Data Source=test;Persist Security Info=True;User ID=t;Password=t");
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand("SELECT T.staff_idiograph FROM staff_idiograph_dict T WHERE T.EMP_NO='1333'");//1333
cmd.Connection = conn;
conn.Open();
OracleDataReader reader = cmd.ExecuteReader();
reader.Read();
MemoryStream buf = new MemoryStream((byte[])reader[0]);
Image image = Image.FromStream(buf, true);
pictureBox1.Image = image;
在 Image image = Image.FromStream(buf, true);执行这句话的时候,提示参数错误。
并且用网上的方法,pb程序保存图片至本地也不能预览。但是在pb自带的ole控件中能预览。
string ls_empno
blob lb_idiograph
ls_empno = sle_1.Text
selectblob staff_idiograph INTO :lb_idiograph from staff_idiograph_dict where emp_no =:ls_empno USING sqlca;
integer li_FileNum
li_FileNum = FileOpen("C:\1333.BMP", StreamMode!, Write!, Shared!,Replace!)
FileWrite(li_FileNum, lb_idiograph)
--------------------编程问答-------------------- 为何不存路径呢
C#存图片和读取 --------------------编程问答--------------------
补充:.NET技术 , C#