Use ASP.NET to store uploaded images to the database

xiaoxiao2021-03-06  139

code:

The project of the alumni record and gallery, etc. have the function of uploading pictures. I put the picture data into the database, you need to put the picture and store the original image into the database, so you can display a lot of small pictures, click on the big picture. Figure! This is done in ASP.NET: changimage.aspx China code: <% @ page language = "vb" autoeventwireup = "false" codebehind = "Changimage.aspx.vb" inherits = "UploadImage.changimage"%> </ title> <meta name = "generator" content = "Microsoft Visual Studio.net 7.0"> <meta name = "code_language" content = "Visual Basic 7.0"> <meta name = "vs_defaultclientscript" content = "javascript"> <meta name = "vs_targetschema" content = "</p> <p>http://schemas.microsoft.com/intellisense/ie5</p> <p>> </ Head> <body ms_positioning = "gridLayout> <form id =" form1 "method =" post "enctype =" multipart / form-data "runat =" server "> <font face =" Song "> < Input id = "file1" style = "z-index: 101; left: 291px; width: 180px; position: absolute; top: 119px; height: 45px" Type = "file" size = "10" name = "file1" Runat = "server"> <ask = "cmdupload" style = "z-index: 103; Left: 402px; position: absolute; top: 194px" runat = "text =" Upload Image "Width =" 81px "Height =" 42px "> </ asp: button> </ font> </ form> </ body> </ html> Changimage.aspx.vb China code as follows: Public class changimage inherits system.web.ui.page Protected WithEvents cmddemo As System.Web.UI.WebControls.Button Protected WithEvents cmdupload As System.Web.UI.WebControls.Button Protected WithEvents sqlConn As System.Data.SqlClient.SqlConnection Protected WithEvents SqlComm As System.Data.SqlClient.SqlCommand Protected WithEvents File1 as system.Web.ui.htmlcontrols.htmlinputfile # region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough ()> Private Sub InitializeComponent () Me.SqlConn = New System.Data.SqlClient.SqlConnection () Me.SqlComm =</p> <p>New System.Data.SqlClient.SqlCommand () End Sub Private Sub Page_Init (ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init Form Designer InitializeComponent () End Sub # End Region Private Sub Page_Load (ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load End Sub Private Sub cmdupload_Click (ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdupload.Click Dim image As System.Drawing.Image, newimage As System.Drawing.Image Dim callb As System.Drawing.Image.GetThumbnailImageAbort Dim f As System.IO.File, fs As System.IO.FileStream Dim temppath As String Dim bigdata As Byte (), smalldata As Byte () 'large Image data, small picture data DIM PIC as system.data.sqlclient.sqlparameter, picsmall asseter, picsmall as system.data.sqlclcent.sqlparameter 'Check that the upload file is equipped with standard, the check function is I need to write according to the website, IF Check (file1.postedfile .Filename <> "ok" the response.write (check (file1.postedfile.fi LENAME)) EXIT SUB END IF 'Sets the temporary path, in order to prevent conflicts when multi-user access, set an application object if Application ("Image") = "" "") = 0 end if application.lock () Temppath = Server.mappath ("Image"))) 'Temporary Path Application ("Image") = Application ("Image" 1 Application.unlock ()' Read the data of the image Redim BigData ( (Me.file1.postedFile.InputStream.Length) Me.file1.postedfile.inputStream.read (BigData, 0, Ubound (BigData) 'Read the original image data to BigData' 'Changing the size image =</p> <p>System.drawing.Image.fromstream (me.file1.postedfile.inputstream) 'NewImage Size can also set up, I only use 80 * 60 and 60 * 80 two kind if image.width> image.Height Ten newimage = Image.getthumbnailimage (80, 60, Callb, New System.intptr (0)) Else newimage = image.getthumbnailimage (60, 80, callb, new system.intptr (0)) end if image.dispose () will And the picture is time to store newimage.save (Temppath, System.drawing.Image.dispose () 'in the temporary path to read the temporary file data into SmallData FS = New System.IO.FileStream (Temppath IO.FileMode.open, IO.FileAccess.read) Redim SmallData (fs.length) fs.read (SmallData, 0, Ubound (SmallData) fs.close () 'The above way to get small pictures, I originally want to use System .io.Memorystream, but not: code as follows: 'Dim M as system.io.MemoryStream'm = new system.io.MemoryStream ()' newimage.save (m, system.drawing.imaging.imageformat.jpeg) 'Redim SmallData (M.LENGTH)' M.Read (SmallData, 0, M.Length) 'But the SmallData read from the above method is empty, do not know why, please advice' delete temporary file IF F.EXISTS (Temppath) ) f.Delete (Temppath) End if 'Adds Data in Database' Due to the image field in the database, I don't insert it with SQL. Use a stored procedure 'to insert the prawn with the SQL statement insertion with an Image field. How to Write 'doesn't work with INSERT INTO TALBE (PIC, PICSMALL) Values ​​("& BigData &", "& BiGData &" is not available! SqlConn = New System.Data.SqlClient.SqlConnection (connstr) 'may be connected to its own database server provided connstr SqlComm = New System.Data.SqlClient.SqlCommand () SqlComm.CommandType = CommandType.StoredProcedure SqlComm.CommandText = "dbo.image" pic = New system.data.sqlclient.sqlparameter ("</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-127396.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="127396" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.044</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'NR2FGwROwl9Tqk0DvLcmSOkuaDtzbl_2Bpt_2FylwIGT9hIIhScknpa6d1UJXdtqIssHhumzGLk_2B_2FZDAMyetElwpiw_3D_3D'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>