简单的图像上传到数据库和retrive [英] simple image upload to database and retrive

问题描述

从数据库上传和检索图像的任何简单想法？我有一个数据库 profile 2 data fields imagename和imagepath

解决方案

试试

如何从SQL Server数据库存储和检索图像使用asp.net [ ^ ]

[ ^ ]

如何存储和检索图像 [ ^ ]

视频 - 使用ASP.Net检索图像 [ ^ ]

存储和检索图像 [ ^ ]

使用System; 
使用System.Collections; 
使用System.Configuration; 
使用System.Data; 
使用System.Linq; 
使用System.Web;使用System.Web.Security 
; 
使用System.Web.UI; 
使用System.Web.UI.HtmlControls; 
使用System.Web.UI.WebControls; 
使用System.Web.UI.WebControls.WebParts; 
使用System.Xml.Linq; 
使用System.Data.SqlClient; 
命名空间fileupld 
 {
 public partial class _Default：System.Web.UI.Page 
 {
 
 SqlConnection con = new SqlConnection（ConfigurationManager.ConnectionStrings [ mycon]的ConnectionString）。 
 protected void Page_Load（object sender，EventArgs e）
 {
 
} 
 
 
 
 protected void onbtnupldclick（object sender ，EventArgs e）
 {
 if（FileUpload1.HasFile）
 {
 
 string fileExtension = System.IO.Path.GetExtension（FileUpload1.FileName）; 
 
 if（fileExtension.ToLower（）！=.jpg&& fileExtension.ToUpper（）！=。jpeg）
 {
 Response.Write（ < script> alert（'请上传.jpeg或仅.jpg文件'）;< / script>）; 
 
} 
 else 
 {
 
 int fileSize = FileUpload1.PostedFile.ContentLength; 
 
 if（fileSize> = 1000000）
 {
 Response.Write（< script> alert（'Please Upload of 1 mb'）;< / script> ;）; 
} 
其他
 {
 con.Open（）; 
 FileUpload1.SaveAs（Server.MapPath（〜/ folder /+ FileUpload1.FileName））; 
 String s1 = FileUpload1.FileName; 
 String s2 =insert into fileupload values（'+ s1 +'）; 
 SqlCommand cmd = new SqlCommand（s2，con）; 
 cmd.ExecuteNonQuery（）; 
 Response.Write（< script> alert（'File Uploaded'）;< / script>）; 
} 
} 
} 
其他
 {
 
 Response.Write（< script> alert（'Please Select The File'） ）;< /脚本>中）; 
} 
} 
 
 protected void btnviewclick（object sender，EventArgs e）
 {
 con.Open（）; 
 string sql =从fileupload中选择文件名; 
 SqlCommand cmd = new SqlCommand（sql，con）; 
 SqlDataAdapter da = new SqlDataAdapter（cmd）; 
 DataTable dt = new DataTable（）; 
 da.Fill（dt）; 
 if（dt.Rows.Count> 0）
 {
 
 // string filePath =Images \\+ dt.Rows [0] [1]的ToString（）; 
 //Response.ContentType =Images / jpg; 
 //Response.AddHeader (\"Content-Disposition，attachment; filename = \+ filePath +\）; 
 //Response.TransmitFile(Server.MapPath(filePath））; 
 //Response.End（）; 
 
 //Response.AppendHeader (\"Content-Disposition，attachment; filename =〜/ folder /+ dt.Rows [0] [0] .ToString（））; 
 
 Response.Write（< script> window.open（'../ Picture /+ dt.Rows [0] [0] .ToString（）+'，' -  blank' ）;< /脚本>中）; 
 
 
 
} 
 
 
 
 
} 
} 
} 

any simple idea to upload and retrive images from database? i have a database profile 2 data filed imagename and imagepath

解决方案

Try
How to store and retrieve images from SQL server database using asp.net[^]
Storing and Retrieving Images from SQL Server using Microsoft .NET[^]
How to Store and Retrieve Images[^]
Video -Retriee Images using ASP.Net[^]
Store and retrieve images[^]

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace fileupld
{
    public partial class _Default : System.Web.UI.Page
    {
     
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mycon"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
           
        }

      

        protected void onbtnupldclick(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {

                string fileExtension = System.IO.Path.GetExtension(FileUpload1.FileName);

                if (fileExtension.ToLower() != ".jpg" && fileExtension.ToUpper() != ".jpeg")
                {
                    Response.Write("<script>alert('Please Upload .jpeg Or .jpg Files only');</script>");

                }
                else
                {

                    int fileSize = FileUpload1.PostedFile.ContentLength;

                    if (fileSize >= 1000000)
                    {
                        Response.Write("<script>alert('Please Upload less of 1 mb');</script>");
                    }
                    else
                    {
                        con.Open();
                        FileUpload1.SaveAs(Server.MapPath("~/folder/" + FileUpload1.FileName));
                        String s1 = FileUpload1.FileName;
                        String s2 = "insert into fileupload values('" + s1 + "')";
                        SqlCommand cmd = new SqlCommand(s2, con);
                        cmd.ExecuteNonQuery();
                        Response.Write("<script>alert('File Uploaded');</script>");
                    }
                }
            }
            else
            {

                Response.Write("<script>alert('Please Select The File');</script>");
            } 
        }

        protected void btnviewclick(object sender, EventArgs e)
        {
            con.Open();
            string sql = "select filename from fileupload";
            SqlCommand cmd = new SqlCommand(sql, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {

                //string filePath = "Images\\" + dt.Rows[0][1].ToString(); 
                //Response.ContentType = "Images/jpg";
                //Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filePath + "\"");
                //Response.TransmitFile(Server.MapPath(filePath));
                //Response.End();  
               
                //Response.AppendHeader("Content-Disposition", "attachment; filename=~/folder/"+ dt.Rows[0][0].ToString());
                
                Response.Write("<script>window.open('../Picture/"+dt.Rows[0][0].ToString()+"','-blank');</script>");
              
                
               
            }

           
                
            
        }
    }
}

这篇关于简单的图像上传到数据库和retrive的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！