读书人

(c#net)怎么把图片存储带数据库里,以后

发布时间: 2012-03-04 11:13:34 作者: rapoo

(c#.net)如何把图片存储带数据库里,以后可以在库里调用显示出来?
2个内容,简单说明一下,谢谢!

[解决办法]
保存图片:

OleDbConnection mycnn=new OleDbConnection( "provider=Microsoft.jet.oledb.4.0;data source=f:\\dazhu.mdb ");
mycnn.Open();

OleDbCommand mycmd=new OleDbCommand( "update info set picture=@a ",mycnn );

FileStream mystream=new FileStream( "f:\\1.jpg ",FileMode.Open,FileAccess.Read);
long len=mystream.Length;

mycmd.Parameters.Add( "@a ",OleDbType.Binary,(int)len, "picture ");
mycmd.Parameters[ "@a "].Direction=System.Data.ParameterDirection.Input;

byte []box=new byte[len];
mystream.Read(box,0,(int)len);

mycmd.Parameters[ "@a "].Value=box;

//更新
mycmd.ExecuteNonQuery();
MessageBox.Show( "ok ");
mystream.Close();
mycnn.Close();

读书人网 >C#

热点推荐