User-105508883 postedReally thanks for you help Sean. My updated code is now this:
Default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="LLPIposAttachment.Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>iPOS Attachment</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2>iPOS Attachments List</h2>
</div>
<asp:GridView ID="AttachmentList" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="ATTACH_NAME" HeaderText="File Name" />
<asp:TemplateField ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:LinkButton ID="lnkDownload" runat="server" Text="Download" OnClick="DownloadFile" CommandArgument='<%# Eval("ATTACH_ID") %>'></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</form>
</body>
</html>
Default.aspx.cs
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace LLPIposAttachment
{
public partial class Default : System.Web.UI.Page
{
SqlConnection sqlCon;
string bu;
string jn;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["BU"] != null)
{
bu = Request.QueryString["BU"].ToString();
}
if (Request.QueryString["JN"] != null)
{
jn = Request.QueryString["JN"].ToString();
}
BindGrid();
}
}
private void BindGrid()
{
sqlCon = new SqlConnection(WebConfigurationManager.AppSettings["inputSqlCon"]);
sqlCon.Open();
string inputSql = @"SELECT atta.ATTACH_ID, atta.ATTACH_NAME
FROM PA_REQ_NOTE_ATTACHMENTS atta join PA_REQ_INVOICES inv on atta.NOTE_ID = inv.NOTE join PK1_A_SALFLDG ldg on ldg.TREFERENCE = 'IP ' + CONVERT(varchar(12), INV_NO)
where inv.SUN_DB = '" + bu + "' and D_C = 'C' and ldg.JRNAL_NO = " + jn;
SqlCommand sqCom = new SqlCommand(inputSql, sqlCon);
SqlDataReader sqRead = sqCom.ExecuteReader();
AttachmentList.DataSource = sqRead;
AttachmentList.DataBind();
sqlCon.Close();
}
protected void DownloadFile(object sender, EventArgs e)
{
string id = (sender as LinkButton).CommandArgument;
(sender as LinkButton).Attributes.Add("href", "./GetFile.aspx");
(sender as LinkButton).Attributes.Add("target", "_blank");
Response.Redirect("./GetFile.aspx?ID=" + id);
}
}
}
GetFile.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GetFile.aspx.cs" Inherits="LLPIposAttachment.GetFile" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>
GetFile.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Configuration;
namespace LLPIposAttachment
{
public partial class GetFile : System.Web.UI.Page
{
string id;
protected void Page_Load(object sender, EventArgs e)
{
id = Request.QueryString["ID"];
GetF();
}
private void GetF()
{
byte[] bytes;
string fileName;
string mimeType;
string constr = WebConfigurationManager.AppSettings["inputSqlCon"];
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = @"SELECT ATTACH_NAME, ATTACH
FROM PA_REQ_NOTE_ATTACHMENTS
where ATTACH_ID = @Id";
cmd.Parameters.AddWithValue("@Id", id);
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
bytes = (byte[])sdr["ATTACH"];
fileName = sdr["ATTACH_NAME"].ToString();
}
con.Close();
}
}
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
mimeType = MimeMapping.GetMimeMapping(fileName);
Response.ContentType = mimeType;
Response.AppendHeader("Content-Disposition", "inline; attachment; filename=" + fileName);
//Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.TransmitFile(Server.MapPath(fileName));
Response.BinaryWrite(bytes);
Response.Flush();
Response.End();
}
}
}
I succesfully pass ATTACH_ID parameter to GetFile page, so I can download file from database. But I don't undestand this part:
Response.TransmitFile(Server.MapPath(fileName));
I am trying to use fileName variable here, because files stored in database which I need to download can be PDF or images. I suppose in this part file should be downloaded, saved, and finally displayed on GetFile page?
But i receive this error, so file isn't downloaded, or it's saved somewhere else?
System.IO.FileNotFoundException: 'Could not find file 'C:\VYVOJ2\SmallDev\LLPIposAttachment\LLPIposAttachment\IPOS_logo11.gif'.'
And again, really thanks for you help here.
