c# win 读取oracle中blob字段的图片并且显示到pictureBox里,保存进库.doc

1. privatevoidbutton2_Click(objectsender,EventArgse) 2. 3. OracleConnectionconn=dbc.getConnection();/获得conn连接 4. try5. 6. conn.Open(); 7. OracleCommandcmd=conn.CreateCommand(); 8. cmd.CommandText=SELECTzpFROMkk.kkbjWHERExh=2345;/查询获得图片流 9. 10. OracleDataReaderreader=cmd.ExecuteReader();/创建一个OracleDateReader对象 11. reader.Read(); 12. 13. MemoryStreamms=newMemoryStream(byte)readerzp); 14. 15. Imageimage=Image.FromStream(ms,true); 16. 17. reader.Close(); 18. conn.Close(); 19. 20. pictureBox1.Image=image; 21. 22. catch(Exceptionee) 23. 24. MessageBox.Show(ee.Message.ToString(); 25. 26. 27. private void button2_Click(object sender, EventArgs e)OracleConnection conn = dbc.getConnection();/获得conn连接tryconn.Open();OracleCommand cmd = conn.CreateCommand();cmd.CommandText = SELECT zp FROM kk.kkbj WHERE xh = 2345 ;/查询获得图片流OracleDataReader reader = cmd.ExecuteReader();/创建一个OracleDateReader对象 reader.Read();MemoryStream ms = new MemoryStream(byte)readerzp);Image image = Image.FromStream(ms, true);reader.Close();conn.Close();pictureBox1.Image = image;catch (Exception ee)MessageBox.Show(ee.Message.ToString();-下边是上传和存入数据库有和winform(转)- 本文总结如何在.Net Winform和.Net webform()中将图片存入sqlserver中并读取显示的方法 1，使用将图片上传并存入SqlServer中，然后从SqlServer中读取并显示出来 一，上传并存入SqlServer 数据库结构 create table test id identity(1,1), FImage image 相关的存储过程 Create proc UpdateImage ( UpdateImage Image ) As Insert Into test(FImage) values(UpdateImage) GO 在UpPhoto.aspx文件中添加如下: C#代码 1. 2. 然后在后置代码文件UpPhoto.aspx.cs添加btnAdd按钮的单击事件处理代码: C#代码 1. privatevoidbtnAdd_Click(objectsender,System.EventArgse) 2. 3. /获得图象并把图象转换为byte 4. HttpPostedFileupPhoto=UpPhoto.PostedFile; 5. intupPhotoLength=upPhoto.ContentLength; 6. bytePhotoArray=newByteupPhotoLength; 7. StreamPhotoStream=upPhoto.InputStream; 8. PhotoStream.Read(PhotoArray,0,upPhotoLength); 9. 10. /连接数据库 11. SqlConnectionconn=newSqlConnection(); 12. conn.ConnectionString=DataSource=localhost;Database=test;UserId=sa;Pwd=sa; 13. 14. SqlCommandcmd=newSqlCommand(UpdateImage,conn); 15. cmd.CommandType=CommandType.StoredProcedure; 16. 17. cmd.Parameters.Add(UpdateImage,SqlDbType.Image); 18. cmd.ParametersUpdateImage.Value=PhotoArray; 19. 20. /如果你希望不使用存储过程来添加图片把上面四句代码改为： 21. /stringstrSql=Insertintotest(FImage)values(FImage); 22. /SqlCommandcmd=newSqlCommand(strSql,conn); 23. /cmd.Parameters.Add(FImage,SqlDbType.Image); 24. /cmd.ParametersFImage.Value=PhotoArray; 25. 26. conn.Open(); 27. cmd.ExecuteNonQuery(); 28. conn.Close(); 29. private void btnAdd_Click(object sender, System.EventArgs e) /获得图象并把图象转换为byte HttpPostedFile upPhoto=UpPhoto.PostedFile; int upPhotoLength=upPhoto.ContentLength; byte PhotoArray=new ByteupPhotoLength; Stream PhotoStream=upPhoto.InputStream; PhotoStream.Read(PhotoArray,0,upPhotoLength); /连接数据库 SqlConnection conn=new SqlConnection(); conn.ConnectionString=Data Source=localhost;Database=test;User Id=sa;Pwd=sa; SqlCommand cmd=new SqlCommand(UpdateImage,conn); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add(UpdateImage,SqlDbType.Image); cmd.ParametersUpdateImage.Value=PhotoArray; /如果你希望不使用存储过程来添加图片把上面四句代码改为： /string strSql=Insert into test(FImage) values(FImage); /SqlCommand cmd=new SqlCommand(strSql,conn); /cmd.Parameters.Add(FImage,SqlDbType.Image); /cmd.ParametersFImage.Value=PhotoArray;conn.Open();cmd.ExecuteNonQuery();conn.Close(); 二，从SqlServer中读取并显示出来 在需要显示图片的地方添加如下代码: C#代码 1. ShowPhoto.aspx主体代码： C#代码 1. privatevoidPage_Load(objectsender,System.EventArgse) 2. 3. if(!Page.IsPostBack) 4. 5. SqlConnectionconn=newSqlConnection() 6. conn.ConnectionString=DataSource=localhost;Database=test;UserId=sa;Pwd=sa; 7. 8. stringstrSql=select*fromtestwhereid=2;/这里假设获取id为2的图片 9. SqlCommandcmd=newSqlCommand() 10. reader.Read(); 11. Response.ContentType=application/octet-stream; 12. Response.BinaryWrite(Byte)readerFImage); 13. Response.End(); 14. reader.Close(); 15. 16. private void Page_Load(object sender, System.EventArgs e) if(!Page.IsPostBack) SqlConnection conn=new SqlConnection() conn.ConnectionString=Data Source=localhost;Database=test;User Id=sa;Pwd=sa; string strSql=select * from test where id=2;/这里假设获取id为2的图片 SqlCommand cmd=new SqlCommand() reader.Read(); Response.ContentType=application/octet-stream; Response.BinaryWrite(Byte)readerFImage); Response.End(); reader.Close(); 3，在winform中将图片存入sqlserver，并从sqlserver中读取并显示在picturebox中 1,存入sqlserver 数据库结构和使用的存储过过程，同上面的一样 1.1,在窗体中加一个OpenFileDialog控件，命名为ofdSelectPic 1.2,在窗体上添加一个打开文件按钮，添加如下单击事件代码： C#代码 1. Streamms; 2. bytepicbyte; 3. /ofdSelectPic.ShowDialog(); 4. if(ofdSelectPic.ShowDialog()=DialogResult.OK) 5. 6. if(ms=ofdSelectPic.OpenFile()!=null) 7. 8. /MessageBox.Show(ok); 9. picbyte=newbytems.Length; 10. ms.Position=0; 11. ms.Read(picbyte,0,Convert.ToInt32(ms.Length); 12. /MessageBox.Show(读取完毕!); 13. 14. /连接数据库 15. SqlConnectionconn=newSqlConnection(); 16. conn.ConnectionString=DataSource=localhost;Database=test;UserId=sa;Pwd=sa; 17. 18. SqlCommandcmd=newSqlCommand(UpdateImage,conn); 19. cmd.CommandType=CommandType.StoredProcedure; 20. 21. cmd.Parameters.Add(UpdateImage,SqlDbType.Image); 22. cmd.ParametersUpdateImage.Value=picbyte; 23. 24. conn.Open(); 25. cmd.ExecuteNonQuery(); 26. conn.Close(); 27. 28. ms.Close(); 29. 30. Stream ms;byte picbyte;/ofdSelectPic.ShowDialog();if (ofdSelectPic.ShowDialog()=DialogResult.OK) if (ms=ofdSelectPic.OpenFile()!=null) /MessageBox.Show(ok); picbyte=new bytems.Length; ms.Position=0; ms.Read(picbyte,0,Convert.ToInt32(ms.Length); /MessageBox.Show(读取完毕!); /连接数据库 SqlConnection conn=new SqlConnection(); conn.ConnectionString=Data Source=localhost;Database=test;User Id=sa;Pwd=sa; SqlCommand cmd=new SqlCommand(UpdateImage,conn); cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add(UpdateImage,SqlDbType.Image); cmd.Parameters