C#(WinForm)上传图片保存到数据库和从数据库读取图片显示到窗体

//浏览图片
 
        private void btnUp_Click(object sender, EventArgs e)
 
        {
 
            OpenFileDialog ofd = new OpenFileDialog();
 
            ofd.Title = "选择要上传的图片";
 
            ofd.Filter = "All Files(*.*)|*.*|位图(*.bmp)|*.bmp|JPEG(*.jpg)|*.jpg";
 
            ofd.ShowDialog();
 
            textBox1.Text = ofd.FileName;
 
            if (!File.Exists(ofd.FileName))
 
            {
 
                MessageBox.Show("照片为空");
 
                return;
 
            }
 
        }
 
  
 
  
 
        //上传保存到数据库
 
        private void btnUpLoad_Click(object sender, EventArgs e)
 
        {
 
            string strPath = txtbImage.Text.Trim();
 
            FileStream fs = new FileStream(strPath, FileMode.Open, FileAccess.Read);
 
            byte[] byteFile = new byte[fs.Length];
 
            fs.Read(byteFile, 0, (int)fs.Length);
 
            fs.Close();
 
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Test;Integrated Security=True");
 
                try
 
                {
 
                    SqlCommand cmd = new SqlCommand();
 
                    cmd.Connection = conn;
 
  
 
                    string strSql = "insert into test(FileName,Img) Values(@FileName,@Img)";
 
                    cmd.CommandText =strSql ;
 
                    //cmd.Parameters.AddWithValue("@FileName", strPath);
 
                    //cmd.Parameters.AddWithValue("@Img", byteFile);
 
                    //或者
 
                    SqlParameter[] parameters = new SqlParameter[2];
 
                    parameters[0] = new SqlParameter("@FileName", SqlDbType.NVarChar, 200);
 
                    parameters[0].Value = strPath;
 
                    parameters[1] = new SqlParameter("@Img", SqlDbType.Image,int.MaxValue);
 
                    parameters[1].Value = byteFile;
 
                    cmd.Parameters.AddRange(parameters);
 
                    conn.Open();
 
                    cmd.ExecuteNonQuery();
 
                    conn.Close();
 
                    MessageBox.Show("上传成功");
 
                }
 
                catch
 
                {
 
                    conn.Close();
 
                    MessageBox.Show("上传失败！");
 
                }
 
        }

从数据库读取图片显示到窗体：
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
//读到图片显示到PictureBox
 
        private void btnDownLoad_Click(object sender, EventArgs e)
 
        {
 
            byte[] bytFile;
 
            SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Test;Integrated Security=True");
 
                try
 
                {
 
                    SqlCommand cmd = new SqlCommand();
 
                    string strSql = "select img from test where ID=3";
 
                    cmd.Connection = conn;
 
                    cmd.CommandText = strSql;
 
                    conn.Open();
 
                    SqlDataReader sdr = cmd.ExecuteReader();
 
                    if (sdr.Read())
 
                    {
 
                        bytFile = (Byte[])sdr["Img"];
 
                    }
 
                    else
 
                    {
 
                        bytFile = new byte[0];
 
                    }
 
                    sdr.Close();
 
                    conn.Close();
 
                    //通过内存流MemoryStream，
 
                    //把byte[]数组fileContent加载到Image中并赋值给图片框的Image属性，
 
                    //让数据库中的图片直接显示在窗体上。
 
                    MemoryStream ms = new MemoryStream(bytFile, 0, bytFile.Length);
 
                    this.picImage.Image = Image.FromStream(ms);
 
                    //关闭内存流
 
                    ms.Close();
 
                }
 
                catch
 
                {
 
                    conn.Close();
 
                    MessageBox.Show("失败");
 
                }
 
        }

代码转自IT学习广场http://www.itxxgc.com/net/detail/30

                 来自凌波小屋-----冯和超的笔记-------