如何绑定上传的图像在fileuploader控件中.image存储在数据库中的文件夹和图像路径中 [英] How Do I Bind a Uploaded Image In fileuploader control .image stored in Folder and Image Path In Database

问题描述

我想在文件上传器控件中绑定一个图像，该控件存储在文件夹中，在数据库中只存储该特定图像的路径。

Hi,
I want to bind a image in file uploader control which stored in folder and in database only a path of that particular image.

推荐答案

ASP表单代码

ASP form code

<div align="center">
        <form id="frmUpload" runat="server">
            <h2>Save Book Details</h2><br />
            Book Name   : &nbsp; <asp:TextBox runat="server" ID="txtBookname" Text=""></asp:TextBox><br /><br />
            Choose File : &nbsp; <asp:FileUpload runat="server" ID="fupPdfBrowse"/><br /><br />
            <asp:Button runat="server" ID="btnSave" text="Upload" onclick="btnSave_Click" /><br /><br />
            <asp:Label runat="server" ID="lblStatus" text="Click on Browsre to Select File and Enter Book Name then Click Save." />
        </form>
</div>

C＃代码

包括这两个

C# Code
Include this two

using System.IO;
using System.Data.SqlClient;

按钮保存点击事件

button Save Click event

protected void btnSave_Click(object sender, EventArgs e)
    {
        if (fupPdfBrowse.HasFile)
        {
            try
            {
                string filename = Path.GetFileName(fupPdfBrowse.FileName);
                fupPdfBrowse.SaveAs(Server.MapPath("~/") + filename);
                lblStatus.Text = "File Uploaded";
                SaveBookDetails(txtBookname.Text, filename);
                
            }
            catch (Exception ex)
            {
                lblStatus.Text = "The file could not be uploaded.Exception : " + ex.Message;
            }
        }
    }

保存方法数据库

method to Save in Database

private void SaveBookDetails(string strBookName, string strFilename)
    {
        try
        {
            string strCmd = "INSERT INTO book (name,filename) VALUES (@name, @filename)";
            string strCon = "your connection string";
            using (SqlConnection con = new SqlConnection(strCon))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.Connection = con;
                    cmd.CommandText = strCmd;
                    cmd.Parameters.AddWithValue("@name", strBookName);
                    cmd.Parameters.AddWithValue("@filename", strFilename);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    lblStatus.Text = "File Saved & uploaded";
                }
            }
        }
        catch (Exception ex)
        {
            lblStatus.Text = "Failed to Save book details in Database. Exception : " + ex.Message.ToString();
        }
    }

这篇关于如何绑定上传的图像在fileuploader控件中.image存储在数据库中的文件夹和图像路径中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！