利用C#从Access数据库中读取图片

1. using System;     
2. using System.Collections.Generic;     
3. using System.ComponentModel;     
4. using System.Data;     
5. using System.Data.OleDb;     
6. using System.Data.SqlClient;     
7. using System.Drawing;     
8. using System.Linq;     
9. using System.Text;     
10. using System.Windows.Forms;     
11. using System.IO;     
12.     
13. namespace WindowsFormsApplication1     
14. {     
15.     public partial class Form1 : Form     
16.     {     
17.         public Form1()     
18.         {     
19.             InitializeComponent();     
20.         }     
21.     
22.         private void button1_Click(object sender, EventArgs e)     
23.         {     
24.             pictureBox1.Image = ConMdb();     
25.         }     
26.         //读取Access数据库中的图片     
27.         private Image ConMdb()     
28.         {     
29.             DataSet ds = new DataSet();     
30.             //定义连接加密ACCESS数据库的字符串，数据库密码为xiangyu     
31.             string strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Application.StartupPath   
32.                                + "//OEMInfo.mdb;Jet OLEDB:Database Password=xiangyu";     
33.             //定义连接数据源信息数据表为Info，其中“标识”项为Ole类型，存储的为数据。     
34.             string sql = "select * from Info";     
35.             OleDbConnection con = new OleDbConnection(strFilePath);     
36.             OleDbDataAdapter da = new OleDbDataAdapter(sql, con);     
37.             try    
38.             {     
39.                 da.Fill(ds);     
40.             }     
41.             catch (Exception ex)     
42.             {     
43.                 throw new Exception(ex.ToString());     
44.             }     
45.             finally    
46.             {     
47.                 con.Close();     
48.                 con.Dispose();     
49.                 da.Dispose();     
50.             }     
51.             Image image = null;     
52.             try    
53.             {     
54.                 MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0]["标识"]);     
55.                 image = Image.FromStream(ms);     
56.             }     
57.             catch (Exception ex)     
58.             {     
59.                 //image = image.Dispose();     
60.                 //throw new Exception(ex.ToString());     
61.             }     
62.             return image;     
63.         }     
64.     }     
65. }