private void btn_Choose_Click(object sender, EventArgs e)
        {
            UserMethod.ShowPic(this.pictureBox1);
        }

 1  public static void ShowPic(PictureBox picBox) 
 2         {
 3             OpenFileDialog ofd = new OpenFileDialog();
 4             ofd.InitialDirectory = @"E:\";
 5             ofd.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files(*.*)|*.*";
 6             ofd.RestoreDirectory = true;
 7 
 8             if (ofd.ShowDialog() == DialogResult.OK)
 9             {
10                 picAddress = ofd.FileName;
11                 Image imge = Image.FromFile(picAddress);
12                 Bitmap bm = new Bitmap(imge, picBox.Width, picBox.Height);
13                 picBox.Image = bm;
14             }
15         }

 1  private void btn_Upload_Click(object sender, EventArgs e)
 2         {
 3             if (UserMethod.picAddress == null)
 4             {
 5                 Byte[] pic = UserMethod.GetContent(UserMethod.picAddress);
 6                 string sql = "insert into tb_MyPic values(@Picture,@PicCategory)";
 7                 SqlParameter[] param = new SqlParameter[2];
 8                 param[0] = new SqlParameter("@Picture", pic);
 9                 param[1] = new SqlParameter("@PicCategory", this.cmbCatogery.Text.Trim());
10                 if (DataBase.getExecuteQuery(sql, param) != 0)
11                 {
12                     MessageBox.Show("添加成功！");
13                 }
14             }
15             else
16             {
17                 MessageBox.Show("请先选择图片！");
18             }
19         }

1 　　　　 public static string picAddress = string.Empty;
2         public static Byte[] GetContent(string filepath)//将指定路径下的文件转换成二进制代码，用于传输到数据库
3         {
4             FileStream fs = new FileStream(filepath, FileMode.Open, FileAccess.Read);
5             Byte[] byData = new Byte[fs.Length];//新建用于保存文件流的字节数组
6             fs.Read(byData, 0, byData.Length);//读取文件流
7             fs.Close();
8             return byData;
9         }

1  public static int getExecuteQuery(string sql, SqlParameter[] param)
2         {
3             getcon();
4             SqlCommand sqlcom = new SqlCommand(sql, My_Conn);
5             sqlcom.Parameters.AddRange(param);
6             return sqlcom.ExecuteNonQuery();
7         }