图片转换2进制

来源:互联网 发布:java 线程池 executor 编辑:程序博客网 时间:2024/04/30 21:53

//图片转换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(); }
原创粉丝点击