ASP.NET数据库中图片存储及读取

来源：作者：出处：巧巧读书 2006-05-06 进入讨论组

  private void button1_click(object sender, system.eventargs e)
  {
   stream imgstream;
   int imglen;

   string imgname_value;
   string imgcontenttype;
   string imguploadedname;

   imgstream  = uploadfile.postedfile.inputstream;
   imglen =  uploadfile.postedfile.contentlength;
   imguploadedname = uploadfile.postedfile.filename;
   byte[] imgbinarydata=new byte[imglen];
   imgcontenttype = uploadfile.postedfile.contenttype;
   imgname_value = imgname.value;

   try
   {
    if(imgname_value.length < 1)
    {
     imgname_value = getlastrightof("\\",imguploadedname );
    }
   }
   catch(exception myex)
   {
    response.write(myex.message);
   }

   int n = imgstream.read(imgbinarydata, 0, imglen);
   int numrowsaffected = mydatabasemethod(imgname_value, imgbinarydata, imgcontenttype);
            if(numrowsaffected > 0)
             response.write( "
uploaded image " );
   else
             response.write ( "
an error occurred uploading the image.d " );
  }
  public string getlastrightof(string lookfor,string mystring)
  {
   int strpos;
   strpos = mystring.lastindexof(lookfor);
   return mystring.substring(strpos + 1);
  }
  public int mydatabasemethod(string imgname,byte[] imgbin,string imgcontenttype)
  {
   sqlconnection connection = new sqlconnection(application["test_conn"].tostring());
   string sql="insert into image (img_name,img_data,img_contenttype) values ( @img_name, @img_data,@img_contenttype )";
   sqlcommand command=new sqlcommand ( sql,connection );

   sqlparameter param0=new sqlparameter ( "@img_name", sqldbtype.varchar,50 );
   param0.value = imgname;
   command.parameters.add( param0 );

   sqlparameter param1=new sqlparameter ( "@img_data", sqldbtype.image );
   param1.value = imgbin;
   command.parameters.add( param1 );

   sqlparameter param2 =new sqlparameter ( "@img_contenttype", sqldbtype.varchar,50 );
   param2.value = imgcontenttype;
   command.parameters.add( param2 );

   connection.open();
   int numrowsaffected = command.executenonquery();
   connection.close();
   return numrowsaffected;
  }

  #region web form designer generated code
  override protected void oninit(eventargs e)
  {
   //
   // codegen：该调用是 asp.net web 窗体设计器所必需的。
   //
   initializecomponent();
   base.oninit(e);
  }

  ///

  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  ///

  private void initializecomponent()
  {
   this.button1.click += new system.eventhandler(this.button1_click);
   this.load += new system.eventhandler(this.page_load);

  }
  #endregion


}
}

------------------------------------------------------------

保留地址 http://www.qqread.com/dotnet/n893105002.html