Sample sharing using database to save pictures after uploading pictures

  This article mainly introduces the upload of pictures after the use of the database to save the picture example, the need for friends can refer to the following

  Code as follows: Httppostedfile upfile = File1.PostedFile; int filelenght = Upfile.contentlength; Decimal FileSize = filelenght/1024; if (filelenght = 0) {    divshowgverror.visible = true;     Lblshowgverror.text = "Please select Upload file";     return; } string strimagename = Upfile.filename; String strimagetype = Strimagename.substring (Strimagename.lastindexof (".")). ToLower (); if (Strimagetype!= ". jpg" && strimagetype!= ". jpeg" && strimagetype!= ". bmp" && Strimagetype!= ". png") {    divshowgverror.visible = true;     Lblshowgverror.text = "Please upload a picture of the following file format: jpg,jpeg,bmp,png ";     return; } if (FileSize > 2048) {    divshowgverror.visible = true;     Lblshowgverror.text = "Upload picture cannot be larger than 2M";     return; else {    byte[] Filebytearray = new Byte[filelenght];     Stream streamobject = Upfile.inputstream ;     Streamobject.read (filebytearray, 0, filelenght); &nBsp     Strnewleave = "INSERT INTO [Leave] ([id],[employeeno],[agentid],[leavetype],[startdate],[enddate],[ Hours],[leaver Eason],[reporttime],[reportid],[imagename],[imagedata]) ";     Strnewleave + = "VALUES (@LeaveNo, @EmpNo, @AgentName, @LeaType, @StartDate, @EndDate, @Hours, @Reason, GETDATE (), @Adm in, @ImageName, @Image) ";       Sqlpara = new sqlparameter[] {      New SqlParameter ("@LeaveNo", Strleano),   &nbs P New SqlParameter ("@EmpNo", Strempno),     new SqlParameter ("@AgentName", Stragentid),     NEW SqlParameter ("@LeaType", Strleatype),     new SqlParameter ("@StartDate", Strdatest),     NEW SqlParameter ("@EndDate", Strdateend),     new SqlParameter ("@Hours", strhours),     New SqlParameter ("@Reason", Strreason),     new SqlParameter ("@Admin", stradmin),     new SqlParameter ("@ImageName", Strimagename),     new SqlParameter ("@Image", Filebytearray)   };       Streamobject.close (); The     code is as follows: SQLHelper SQLH = new SQLHelper ();         String Strid = context. request["ID"];         byte[] MyData = new Byte[0];         String str = " select [ImageData] from [Leave] where [id]= '" + Strid + "]";         DataTable dt = sqlh.executequery (str, commandtype.text);         if (dt. Rows.Count > 0)         {MyData = (byte[]) dt. ROWS[0][0]; int arraysize = mydata.getupperbound (0);   context. Response.OutputStream.Write (MyData, 0, arraysize);        }