C#与sql进行图片存取

using System;

using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;
namespace 图片存取
{
    public partial class 实例 : Form
    {
        public 实例()
        {
            InitializeComponent();
        }
        public static string str = "server=192.168.0.102;database=mysql;uid=sa;pwd=a123456";
        private void 实例_Load(object sender, EventArgs e)
        {
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="path"></param>
        public static void InsertImg(string path)
        {
            byte[] bytes = File.ReadAllBytes(path);
            SqlConnection con = new SqlConnection(str);
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into table_2 values(@image)",con);
            cmd.Parameters.Add("@image", SqlDbType.Image).Value = bytes;
            cmd.ExecuteNonQuery();
            con.Close();
            //cmd.Dispose();
        }
        public static void ReadImg(string path)
        {
            SqlConnection con = new SqlConnection(str);
            con.Open();
            SqlCommand cmd = new SqlCommand("select image from table_2 ",con);
            object scalar = cmd.ExecuteScalar();
            byte[] bytes = (byte[])scalar;
            File.WriteAllBytes(path, bytes);
            con.Close();
            //cmd.Dispose();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            InsertImg(@"C: \Users\Administrator\Desktop\0811\3-2.jpg");
            ReadImg(@"C: \Users\Administrator\Desktop\0811\3-2-1.jpg");
        }
    }
}