图片转换2进制

最新推荐文章于 2024-09-15 20:39:09 发布

janenone

最新推荐文章于 2024-09-15 20:39:09 发布

阅读量564

点赞数

文章标签： byte object image string insert c#

本文链接：https://blog.csdn.net/janenone/article/details/4011524

版权

//图片转换2进制

C# code

   
   
    
    
    
     
    
    protected
    
     
    
    void
    
     btnUpload_Click1(
    
    object
    
     sender, EventArgs e)
    {
        SqlConnection con 
    
    =
    
     
    
    new
    
     SqlConnection(Sql);
        con.Open();
        FileStream fs 
    
    =
    
     File.Open(
    
    this
    
    .File1.PostedFile.FileName, FileMode.Open);
        
    
    byte
    
    [] by 
    
    =
    
     
    
    new
    
     
    
    byte
    
    [fs.Length];
        fs.Read(by, 
    
    0
    
    , (
    
    int
    
    )fs.Length);
        String SqlCmd 
    
    =
    
     
    
    "
    
    insert into ImageStore(ImageData,ImageContentType,ImageDescription,ImageSize) values(@Image,@fileType,@fileDec,@fileSize)
    
    "
    
    ;
        SqlCommand CmdObj 
    
    =
    
     
    
    new
    
     SqlCommand(SqlCmd, con);
        CmdObj.Parameters.Add(
    
    "
    
    @Image
    
    "
    
    , SqlDbType.Image, (
    
    int
    
    )fs.Length).Value 
    
    =
    
     by;
        CmdObj.Parameters.Add(
    
    "
    
    @fileType
    
    "
    
    , SqlDbType.VarChar, 
    
    20
    
    ).Value 
    
    =
    
     
    
    this
    
    .File1.PostedFile.ContentType;
        CmdObj.Parameters.Add(
    
    "
    
    @fileDec
    
    "
    
    , SqlDbType.VarChar, 
    
    200
    
    ).Value 
    
    =
    
     
    
    this
    
    .txtDescript.Text;
        CmdObj.Parameters.Add(
    
    "
    
    @fileSize
    
    "
    
    , SqlDbType.BigInt).Value 
    
    =
    
     
    
    this
    
    .File1.PostedFile.ContentLength;
        fs.Close();
        CmdObj.ExecuteNonQuery();
        dataGridBind();

    }

2进制转换图片

C# code

   
   
    
    
    
    private
    
     
    
    void
    
     Page_Load(
    
    object
    
     sender, System.EventArgs e)
    {
        
    
    string
    
     strImageID 
    
    =
    
     Request.QueryString[
    
    "
    
    id
    
    "
    
    ];
        SqlConnection myConnection 
    
    =
    
     
    
    new
    
     SqlConnection(Sql);
        SqlCommand myCommand 
    
    =
    
     
    
    new
    
     SqlCommand(
    
    "
    
    Select ImageContentType, ImageData from ImageStore Where ImgID=
    
    "
    
    
            
    
    +
    
     strImageID, myConnection);

        
    
    try
    
    
        {
            myConnection.Open();
            SqlDataReader myDataReader;
            myDataReader 
    
    =
    
     myCommand.ExecuteReader(CommandBehavior.CloseConnection);
            
    
    if
    
     (myDataReader.Read())
            {
                Response.Clear();
                Response.ContentType 
    
    =
    
     myDataReader[
    
    "
    
    ImageContentType
    
    "
    
    ].ToString();
                Response.BinaryWrite((
    
    byte
    
    [])myDataReader[
    
    "
    
    ImageData
    
    "
    
    ]);
            }
            myConnection.Close();
        }
        
    
    catch
    
     (SqlException SQLexc)
        {
            Response.Write(
    
    "
    
    提取数据时出现错误：
    
    "
    
     
    
    +
    
     SQLexc.ToString());
        }
        Response.End();

    }