图片保存到数据库和从数据库读取图片并显示（C＃）

图片保存到数据库的方法：

 <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> public void imgToDB(string sql)<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> { <wbr> <wbr> //参数sql中要求保存的imge变量名称为@images<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> //调用方法如：imgToDB("update UserPhoto set Photo=@images where UserNo='" + temp + "'");<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> FileStream fs = File.OpenRead(t_photo.Text);<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> byte[] imageb = new byte[fs.Length];<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> fs.Read(imageb, 0, imageb.Length);<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> fs.Close();<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> SqlCommand com3 = new SqlCommand (sql,con);<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> com3.Parameters.Add("@images", SqlDbType.Image).Value = imageb;<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> if (com3.Connection.State == ConnectionState.Closed)<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> com3.Connection.Open();<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> try<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> {<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> com3.ExecuteNonQuery();<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> }<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> catch<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> { }<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> finally<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> { com3.Connection.Close(); }<br>  <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> <wbr> }<br><br><strong>数据库中读出图片并显示在picturebox中：</strong><br><br><span style="color: red">方法一：</span><br> private void ShowImage(string sql)<br>  <wbr> <wbr> <wbr> <wbr> {<br>  <wbr> <wbr> <wbr> <wbr> //调用方法如：ShowImage("select Photo from UserPhoto where UserNo='" + <wbr>userno +"'");<br>  <wbr> <wbr> <wbr> <wbr> SqlCommand cmd = new SqlCommand(sql, conn);<br>  <wbr> <wbr> <wbr> <wbr> conn.Open();<br>  <wbr> <wbr> <wbr> <wbr> byte[] b= (byte[])cmd.ExecuteScalar();<br>  <wbr> <wbr> <wbr> <wbr> if (b.Length 〉 0)<br>  <wbr> <wbr> <wbr> <wbr> {<br>  <wbr> <wbr> <wbr> <wbr> MemoryStream stream = new MemoryStream(b, true);<br>  <wbr> <wbr> <wbr> <wbr> stream.Write(b, 0, b.Length);<br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>