ASP.NET利用.FileUpload上传图片并将图片名称保存到数据库

 

private void sqlinsert(string sql)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;User ID=sa;Password=123;Initial Catalog=kxjm_DB";
        conn.Open();
        SqlCommand command = new SqlCommand(sql, conn);
        command.ExecuteNonQuery();    

    }

 
    protected void MessageBox(string str) 
    { 
        Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('"+str+"');</script>");  
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Boolean fileOK = false;
        //获取上传的文件名 
        string fileName = this.FileUpload1.FileName;

        //获取物理路径 
        string path = Server.MapPath("~/upImg/") + fileName;

        //判断上传控件是否上传文件 
        if (FileUpload1.HasFile)
        {
            //判断上传文件的扩展名是否为允许的扩展名".gif", ".png", ".jpeg", ".jpg" ,".bmp" 
            string fileExtension = System.IO.Path.GetExtension(fileName).ToLower();
            string[] Extensions = { ".gif", ".png", ".jpeg", ".jpg", ".bmp" };
            for (int i = 0; i < Extensions.Length; i++)
            {
                if (fileExtension == Extensions[i])
                {
                    fileOK = true;
                }
            }
        }
        //如果上传文件扩展名为允许的扩展名，则将文件保存在服务器上指定的目录中 
        if (fileOK)
        {
            try
            {
                this.FileUpload1.PostedFile.SaveAs(path);
                MessageBox("文件上传完毕");
            }
            catch (Exception ex)
            {
                MessageBox("文件不能上传，原因：" + ex.Message);
            }
        }
        else
        {
            MessageBox("不能上传这种类型的文件");
        }  

        string id = Guid.NewGuid().ToString();        //取Guid做主键
        string sql = "insert into goods values ('" + id + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + fileName + "','" + TextArea1.Value.ToString()+ "','未交易')";
        sqlinsert(sql);
        Response.Redirect("taobao.aspx");
    }