(转)C#数据库存取图片

SqlConnection conn = new  SqlConnection( @" data source=chenyuming2004VSdotNET;uid=sa;pwd=cym;database=lhf " );
conn.Open();
SqlCommand cmd = new  SqlCommand( " insert into fuser values ('1a','1b',@i) " ,conn);
byte [] ib = new  Byte[ 60000 ];
FileStream fs = new  FileStream( @" D:windows temp emp.jpg " ,FileMode.Open ,FileAccess.Read );
fs.Read(ib, 0 , 60000 );
cmd.Parameters.Add( " @i " ,SqlDbType.Image,( int )fs.Length);
cmd.Parameters[ " @i " ].Value = ib;
cmd.ExecuteNonQuery();
conn.Close();

-------------------------------------------------------
从数据库读图片到picturebox

SqlConnection conn = new  SqlConnection( @" data source=chenyuming2004VSdotNET;uid=sa;pwd=cym;database=lhf " );
conn.Open();
SqlCommand cmd = new  SqlCommand( " select 照片 from fuser where password='1b' " ,conn);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
MemoryStream buf = new  MemoryStream(( byte [])reader[ 0 ]);
Image image = Image.FromStream(buf, true );
pictureBox1.Image = image;

转载于:https://www.cnblogs.com/zwei1121/archive/2006/12/19/596708.html