日期:2014-05-16  浏览次数:20386 次

数据库读取和保存图片
//从数据库读取图片,并保存为11.jpg
using (SqlConnection vConn = new SqlConnection(mConnStr))
        {
            vConn.Open();
            using (SqlCommand vCmd = new SqlCommand("select picture from tbUsers", vConn))
            {
                SqlDataReader dr = vCmd.ExecuteReader();
                if (dr.Read())
                {
                    byte[] photo = dr[0] as byte[];
                    FileStream fs = new FileStream(Server.MapPath("~/11.jpg"), FileMode.CreateNew);
                    fs.Write(photo, 0, photo.Length);
                    fs.Close();
                }
                dr.Close();
            }
        }
//保存图片到数据库
FileStream fs = new FileStream(@"E:\1.jpg", FileMode.Open, FileAccess.Read);
        BinaryReader rd = new BinaryReader(fs);
        byte[] vPhoto = rd.ReadBytes((int)fs.Length);
rd.Close();
        fs.Close();
        using (SqlConnection vConn = new SqlConnection(mConnStr))
        {
            vConn.Open();
            using (SqlCommand vCmd = new SqlCommand("insert into tbusers(username,picture) values(@username,@picture)", vConn))
            {
                vCmd.Parameters.Add(new SqlParameter("@username", "张三"));
                vCmd.Parameters.Add(new SqlParameter("@picture", vPhoto));
                vCmd.ExecuteNonQuery();
            }
        }