如何使用数据库中的超链接显示gridview [英] How to display gridview with hyperlinks from database

问题描述

大家好，





我在BLOG格式的mysql数据库中存储pdf文件。



i希望在数据库中显示gridview中的pdf超链接，点击超链接，其各自的pdf文档必须显示在其他页面中。请帮我这样做。

hi all,


i'm storing pdf documents in BLOB format in mysql database.

i want to display pdf hyperlinks in gridview from database and on click of the hyperlink its respective pdf document has to be displayed in other page.please help me to do this.

推荐答案

在Default.aspx页面中

In Default.aspx page

<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="UploadFile" />
<hr />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" EmptyDataText = "No files uploaded">
    <Columns>
        <asp:BoundField DataField="Text" HeaderText="File Name" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="lnkDownload" Text = "Download" CommandArgument = '<%# Eval("Value") %>' runat="server" OnClick = "DownloadFile"></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID = "lnkDelete" Text = "Delete" CommandArgument = '<%# Eval("Value") %>' runat = "server" OnClick = "DeleteFile" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Default.aspx.cs文件：



protected void Page_Load（object sender，EventArgs e）

{

if（！IsPostBack）

{

string [] filePaths = Directory.GetFiles（Server.MapPath（〜/ Uploads / ））;

列表< listitem> files = new List< listitem>（）;

foreach（filePaths中的字符串filePath）

{

files.Add（new ListItem（Path） .GetFileName（filePath），filePath））;

}

GridView1.DataSource = files;

GridView1.DataBind（）;

}

}

Default.aspx.cs File :

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string[] filePaths = Directory.GetFiles(Server.MapPath("~/Uploads/"));
List<listitem> files = new List<listitem>();
foreach (string filePath in filePaths)
{
files.Add(new ListItem(Path.GetFileName(filePath), filePath));
}
GridView1.DataSource = files;
GridView1.DataBind();
}
}

protected void UploadFile(object sender, EventArgs e)
{
    string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
    FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Uploads/") + fileName);
    Response.Redirect(Request.Url.AbsoluteUri);
}

protected void DownloadFile(object sender, EventArgs e)
{
    string filePath = (sender as LinkButton).CommandArgument;
    Response.ContentType = ContentType;
    Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
    Response.WriteFile(filePath);
    Response.End();
}

protected void DeleteFile(object sender, EventArgs e)
{
    string filePath = (sender as LinkButton).CommandArgument;
    File.Delete(filePath);
    Response.Redirect(Request.Url.AbsoluteUri);
}

这篇关于如何使用数据库中的超链接显示gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！