Asp.net中图片存储数据库以及页面读取显示通用方案-附源码

直接在数据库存储图片对资源图片较多, 图片文件较大 类似银行内部系统中对VIP用户签名就是用签名图片方式存储的 这主要为了安全上考虑,实际需求中使用次数频繁 且常常更新 无疑中这种使数据库中数据显得有些臃肿 数据容量增大，同时也增加了访问数据库服务器的负载,而使用存储图片路径的方式:图片文件放在服务器硬盘上,数据库中只需一个文件路径指向硬盘上图片文件即可 存储方式相比存储字节流要简单容易控制 但是我在网上发现关于这种页面显示的诸多问题如下我说明一下再Asp.net对图片页面显示控制:

/// <summary>
         /// 上传文件同时并保存到数据中统一
         /// Author:chenkai Date:2010年2月2日16:24:29
         /// </summary>
         protected void Button1_Click(object sender, EventArgs e)
         {
             //获取数据
             string getname = this.markname.Text;
             string getfile = this.FileUpload1.PostedFile.FileName;
 
             //上传文件
             string getlastpath = FileUploadCompant(this.FileUpload1);
 
             //获取上传文件流
               byte[] getbyte=new byte[this.FileUpload1.PostedFile.ContentLength];
               Stream filestream = this.FileUpload1.PostedFile.InputStream;
              
             //读入数据
              filestream.Read(getbyte, 0, this.FileUpload1.PostedFile.ContentLength);
 
             //插入数据
              #region
              string sql = "insert into StoreImage(markname,markContent,markType,markSize,markLinkUrl) values(@name,@content,@type,@size,@link)";
 
              SqlParameter[] getpars = new SqlParameter[5];
              getpars[0] = new SqlParameter("@name", getname);
              getpars[1] = new SqlParameter("@content", getbyte);//文件内容插入This.Fileupload1.FileBytes同样可以直接转换成Byte数组不用转换
              getpars[2] = new SqlParameter("@type", this.FileUpload1.PostedFile.ContentType);//保存文件类型
              getpars[3] = new SqlParameter("@size", this.FileUpload1.PostedFile.ContentLength);//文件长度
              getpars[4] = new SqlParameter("@link", getlastpath);
 
              int getrescount = DBUtility.SqlHelper.ExecuteNonQuery(DBUtility.SqlHelper.connString,CommandType.Text,sql,getpars);
 
              if (getrescount == 1)
              {
                  //添加成功
                  ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "aler ", "alert( '图片记录成功添加到数据库'); ", true);
              }
              else
              {
                   //添加失败
                  ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "aler ", "alert( '图片记录添加失败'); ", true);
              }
               
              #endregion
         }

资源下载

此资源下载价格为2D币（VIP免费），请先登录

资源文件列表

TestNetWorkConAPI/TestNetWorkConAPI/App_Data/SqlHelper(chenkai修订编写).cs , 160310
TestNetWorkConAPI/TestNetWorkConAPI/Properties/AssemblyInfo.cs , 1336
TestNetWorkConAPI/TestNetWorkConAPI/Default.aspx.cs , 6066
TestNetWorkConAPI/TestNetWorkConAPI/Web.config , 7302
TestNetWorkConAPI/TestNetWorkConAPI/TestImageStoreToDB.aspx , 2664
TestNetWorkConAPI/TestNetWorkConAPI/TestNetWorkConAPI.csproj , 5601
TestNetWorkConAPI/TestNetWorkConAPI/bin/TestNetWorkConAPI.dll , 34304
TestNetWorkConAPI/TestNetWorkConAPI/bin/TestNetWorkConAPI.pdb , 93696
TestNetWorkConAPI/TestNetWorkConAPI/obj/Debug/TestNetWorkConAPI.dll , 34304
TestNetWorkConAPI/TestNetWorkConAPI/obj/Debug/TestNetWorkConAPI.csproj.FileListAbsolute.txt , 452
TestNetWorkConAPI/TestNetWorkConAPI/obj/Debug/TestNetWorkConAPI.pdb , 93696
TestNetWorkConAPI/TestNetWorkConAPI/TestClintJavaScirpt.aspx , 1583
TestNetWorkConAPI/TestNetWorkConAPI/TestClintJavaScirpt.aspx.cs , 523
TestNetWorkConAPI/TestNetWorkConAPI/TestClintJavaScirpt.aspx.designer.cs , 1550
TestNetWorkConAPI/TestNetWorkConAPI/TestDelegate.aspx , 965
TestNetWorkConAPI/TestNetWorkConAPI/TestDelegate.aspx.cs , 3294
TestNetWorkConAPI/TestNetWorkConAPI/TestDelegate.aspx.designer.cs , 1199
TestNetWorkConAPI/TestNetWorkConAPI/TestImageStoreToDB.aspx.cs , 15307
TestNetWorkConAPI/TestNetWorkConAPI/Default.aspx , 632
TestNetWorkConAPI/TestNetWorkConAPI/TestNetWorkConAPI.csproj.user , 1228
TestNetWorkConAPI/TestNetWorkConAPI/TestImageStoreToDB.aspx.designer.cs , 4954
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-04-59-42ieoswvmobmxg0saih0o55p45a43680.jpg , 11495
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-05-03-38en2jpn55c32ud3fpsnokgw55http_imgload.jpg , 43600
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-05-11-23fmbjyu45bl3zqa55i1hygqephttp_imgload4.jpg , 173297
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-05-12-535rf2wc55lpp2ejaxtxpps1zahttp_imgload4.jpg , 173297
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-05-26-48jz4nbv45oakz3h45r32e1y3gBackground.bmp , 513810
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-06-03-12g0dngkyr0xxmr045aotqm4bwhttp_imgload6.jpg , 126038
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-02-07-15-252zxpdg45dhtxc5451k3dz54520100125142513b576.jpg , 6640
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-03-08-35-47rr4hnz45msimfqzh4tcdv545http_imgload6.jpg , 126038
TestNetWorkConAPI/TestNetWorkConAPI/FileuploadDict/2010-02-03-09-49-17nbca3rq1xlr3fmfzzzmh0o55http_imgload3.jpg , 81215
TestNetWorkConAPI/TestNetWorkConAPI/Default.aspx.designer.cs , 855
TestNetWorkConAPI/TestNetWorkConAPI/OutPutImageDemo.aspx , 595
TestNetWorkConAPI/TestNetWorkConAPI/OutPutImageDemo.aspx.cs , 1482
TestNetWorkConAPI/TestNetWorkConAPI/OutPutImageDemo.aspx.designer.cs , 862
TestNetWorkConAPI/TestNetWorkConAPI.sln , 941
TestNetWorkConAPI/TestNetWorkConAPI.suo , 47616