ado.net用sql server中的image列来存取一个图片

最新推荐文章于 2021-03-18 09:10:55 发布

overmind

最新推荐文章于 2021-03-18 09:10:55 发布

阅读量1.6k

点赞数

分类专栏： .net 文章标签： sql server image string textbox security command

本文链接：https://blog.csdn.net/overmind/article/details/278142

版权

.net 专栏收录该内容

51 篇文章 0 订阅

订阅专栏

表的结构
3 ID int 4 0
0 IMGTITLE char 50 1
0 IMGTYPE char 50 1
0 IMGDATA image 16 1

存图片store.aspx

  protected System.Web.UI.HtmlControls.HtmlInputFile File1;//上传文件用
  protected System.Web.UI.WebControls.TextBox TextBox1;
  protected System.Web.UI.WebControls.Button Button1;//填写文件名用

  private void Button1_Click(object sender, System.EventArgs e){
   Stream imgdatastream = File1.PostedFile.InputStream;
   int imgdatalen = File1.PostedFile.ContentLength;
   string imgtype = File1.PostedFile.ContentType;
   string imgtitle = TextBox1.Text;
   byte[] imgdata = new byte[imgdatalen];
   int n = imgdatastream.Read(imgdata,0,imgdatalen);
   string connstr = "workstation id=OVERMIND;packet size=4096;user id=sa;password=sa;data source=OVERMIND;persist security info=False;initial catalog=wztj";
   SqlConnection connection = new SqlConnection(connstr);
   SqlCommand command = new SqlCommand("INSERT INTO ImageStore(imgtitle,imgtype,imgdata) VALUES ( @imgtitle, @imgtype,@imgdata )", connection );
         SqlParameter paramTitle = new SqlParameter("@imgtitle", SqlDbType.VarChar,50 );
   paramTitle.Value = imgtitle;
   command.Parameters.Add( paramTitle);
   SqlParameter paramData = new SqlParameter( "@imgdata", SqlDbType.Image );
   paramData.Value = imgdata;
   command.Parameters.Add( paramData );
   SqlParameter paramType = new SqlParameter( "@imgtype", SqlDbType.VarChar,50 );
   paramType.Value = imgtype;
   command.Parameters.Add( paramType );
   connection.Open();
   int numRowsAffected = command.ExecuteNonQuery();
   connection.Close();
  }

取图片getImage.aspx

  private void Page_Load(object sender, System.EventArgs e)
  {
   string imgid ="1";//Request.QueryString["imgid"];

   string connstr="workstation id=OVERMIND;packet size=4096;user id=sa;password=sa;data source=OVERMIND;persist security info=False;initial catalog=wztj";
   string sql="SELECT imgdata, imgtype FROM ImageStore WHERE id = " + imgid;
   SqlConnection connection = new SqlConnection(connstr);
   SqlCommand command = new SqlCommand(sql, connection);
   connection.Open();
   SqlDataReader dr = command.ExecuteReader();
   if(dr.Read())
   {
    Response.ContentType = dr["imgtype"].ToString();
    Response.BinaryWrite( (byte[]) dr["imgdata"] );
    //Response.WriteFile(
   }
   connection.Close();
   // Put user code to initialize the page here
  }

调用getImage.aspx的页面show.htm
<img src=“getImage.aspx?id=...“></img>