图片存储与读取

存储图片

try
            {
                string strConn = "Server=.;DataBase=tempdb;Integrated Security=true";
                SqlConnection connection = new SqlConnection(strConn);
                string sql = "insert into Images (blobdata) values (@blobdata)";
                SqlCommand command = new SqlCommand(sql, connection);
                //图片路径
                string picturePath = @"D:/pic.jpg";  //注意，这里需要指定保存图片的绝对路径和图片 

                                               //文件的名称，每次必须更换图片的名称，这里很为不便
                //创建FileStream对象
                FileStream fs = new FileStream(picturePath, FileMode.Open, FileAccess.Read);
                //声明Byte数组
                Byte[] mybyte = new byte[fs.Length];
                //读取数据
                fs.Read(mybyte,0,mybyte.Length);
                fs.Close();
                //转换成二进制数据，并保存到数据库
                SqlParameter prm = new SqlParameter
("@blobdata",SqlDbType.VarBinary,mybyte.Length,ParameterDirection.Input,false,0,0,null,DataRowVersion.Current,mybyte);
                command.Parameters.Add(prm);
                //打开数据库连接
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
       

读取图片
            try
            {
                //创建数据库连接字符串
                string strConn = "Server=.;DataBase=tempdb;Integrated Security=True";
                //创建SqlConnection对象
                SqlConnection connection = new SqlConnection(strConn);
                //打开数据库连接
                connection.Open();
                //创建SQL语句
                string sql = "select blodid,blobdata from Images order by blodid";
                //创建SqlCommand对象
                SqlCommand command = new SqlCommand(sql, connection);
                //创建DataAdapter对象
                SqlDataAdapter dataAdapter = new SqlDataAdapter(command);
                //创建DataSet对象
                DataSet dataSet = new DataSet();
                dataAdapter.Fill(dataSet, "BLOBTest");
                int c = dataSet.Tables["BLOBTest"].Rows.Count;
                if (c > 0)
                {
                    Byte[] mybyte = new byte[0];
                    mybyte = (Byte[])(dataSet.Tables["BLOBTest"].Rows[c - 1]["BLOBData"]);
                    MemoryStream ms = new MemoryStream(mybyte);
                    pictureBox1.Image = Image.FromStream(ms);
                }
                connection.Close();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }