ASP.Net 照片数据（二进制数据）读取和写入简单举例

来源：互联网发布：ubuntu xrdp无法连接编辑：程序博客网时间：2024/05/08 11:09

//保存照片数据

public int SavePhoto(string photeFile)
    {
        //读取文件流
        FileStream fs = new FileStream(photeFile,FileMode.Open,FileAccess.Read);
        BinaryReader reader =new BinaryReader(fs);
        byte[] photo = reader.ReadBytes((int)fs.Length);
        reader.Close();
        fs.Close();
        string sql = "update student set zhaopian=@zhaopian where xuehao='001'";
        DataTable dt = new DataTable();
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True";
        SqlCommand command = new SqlCommand(sql, conn);
        SqlParameter parm = new SqlParameter("@zhaopian", photo);
        command.Parameters.Add(parm);
        try
        {
            conn.Open();
            return command.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            return -1;
        }
        finally
        {
            conn.Close();
        }
    }

//读取二进制数据重新保存为新文件，新文件和旧文件大小相同

    public void ReadPhoto(string photeFile)
    {
        string sql = "select zhaopian from student where xuehao='001'";
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True";
        SqlCommand command = new SqlCommand(sql,conn);
        try
        {
            conn.Open();
            SqlDataReader reader = command.ExecuteReader();
            while(reader.Read())
            {
                byte[] photo = reader[0] as byte[];
                FileStream fs = new FileStream(photeFile,FileMode.CreateNew);
                fs.Write(photo,0,photo.Length);
                fs.Close();
            }
            reader.Close();
        }
        catch (SqlException ex)
        {

        }
        finally
        {
            conn.Close();
        }
    }

0 0