Generate PDF on Button click with Hyperlink from database using C# in ASP.Net

Kibock

SOLVED CLOSED ACTIVE ANSWERED
User: Kibock
Posted: on Oct 04, 2017 12:26 AM
Forum: ASP.Net Thirdparty controls
Answer: 2
Views: 7769

Dear All,

I am generating PDF on Button Click. The Pdf includes filenames with hyperlink to the server folder. The file names are retrieved base on GridView row column. The method is fine if there is only one file in the row column. In case of several files in a row column, the hyperlink get concatenated in one link. as shown below

http://i68.tinypic.com/2hh3r49.jpg

I am using the following methods:

                    Chunk imdb = new Chunk("\n" + GetDocumentsExportFileName(Convert.ToInt32(dr["BruddLosID"]), false), FontFactory.GetFont("Arial", 7, Font.NORMAL, Color.BLUE));
                    imdb.SetAnchor(new Uri(GetDocumentsExport("BruddLosPerson", Convert.ToInt32(dr["BruddLosID"]), true, false, false)));
                    phrase = new Paragraph("Click containing links ");
                    phrase.Add(imdb);

                    cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);

                    table.AddCell(cell);

        public string GetDocumentsExport(string folderName, int id, bool isEditable = true, bool isDeletable = false, bool isAdmin = false)
        {
            string constr = ConfigurationManager.ConnectionStrings["DataString1"].ConnectionString;

            string documents = "";

            SqlConnection sqlConn = new SqlConnection(constr);

            sqlConn.Open();
            string sqlQuery = "Select * from brudd_PostedFile where bruddid = " + id + " And IsAdmin = '" + isAdmin + "'";

            SqlCommand sqlCmd = new SqlCommand();
            sqlCmd.Connection = sqlConn;
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.CommandText = sqlQuery;

            SqlDataAdapter sqlAdp = new SqlDataAdapter(sqlCmd);
            DataSet ds = new DataSet();
            sqlAdp.Fill(ds);

            for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
            {
               // string FilePath = "/Upload/" + folderName + "/" + Convert.ToString(ds.Tables[0].Rows[i]["FileName"]);

                if (isEditable)
                {
                    if (!isDeletable) // = TRUE VALUE
                    {
                        if (isAdmin) // NOT ADMIN
                        {
                            documents += GetAbsoluteUrl("~/Upload/BruddLosAdmin/") + Convert.ToString(ds.Tables[0].Rows[i]["FileName"]) + "\n";
                        }
                        else if (!isAdmin) // ADMIN
                        {
                            documents += GetAbsoluteUrl("~/Upload/BruddLosPerson/") + Convert.ToString(ds.Tables[0].Rows[i]["FileName"]) + "\n";
                        }
                    }
                }
                else
                    documents += Convert.ToString(ds.Tables[0].Rows[i]["FileName"]);
            }
            sqlConn.Close();

            return documents;
        }

        private string GetAbsoluteUrl(string relativeUrl)
        {
            relativeUrl = relativeUrl.Replace("~/", string.Empty);

            string[] splits = Request.Url.AbsoluteUri.Split('/');

            if (splits.Length >= 2)
            {
                string url = splits[0] + "//";

                for (int i = 2; i < splits.Length - 1; i++)
                {
                    url += splits[i];
                    url += "/";
                }
                return url + relativeUrl;
            }
            return relativeUrl;
        }

How to solve this issue?

Many thanks

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 2

Reply
ANSWER
User: kalpesh
Replied: on Oct 04, 2017 03:51 AM
Report

Hi Kibock,

Kibock says:
Chunk imdb = new Chunk("\n" + GetDocumentsExportFileName(Convert.ToInt32(dr["BruddLosID"]), false), FontFactory.GetFont("Arial", 7, Font.NORMAL, Color.BLUE));

imdb.SetAnchor(new Uri(GetDocumentsExport("BruddLosPerson", Convert.ToInt32(dr["BruddLosID"]), true, false, false)));

phrase = new Paragraph("Click containing links ");

phrase.Add(imdb);

You need to modify above line of code as there may be multiple attachment link. Current code will work as one attachment with it text (all attachment filename) and its url (all attachment file url). For multiple attachment you always need to create new chunk and need to set its SetAnchor value also add it into phrase.

See below example for your understandability.

Document document = new Document(PageSize.A4, 88f, 88f, 10f, 10f);
iTextSharp.text.Font NormalFont = FontFactory.GetFont("Arial", 12f, BaseColor.BLACK);
using (System.IO.MemoryStream memoryStream = new System.IO.MemoryStream())
{
    PdfWriter writer = PdfWriter.GetInstance(document, memoryStream);
    Phrase phrase = null;
    PdfPCell cell = null;
    PdfPTable table = null;
           

    table = new PdfPTable(1);
    phrase = new Paragraph("Click containing links ");

    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[1] { new DataColumn("FileName", typeof(string)) });

    dt.Rows.Add("33_KvalaBehandking.jpg");
    dt.Rows.Add("33_oversendelsetildep1mars.pdf");

    for (int i = 0; i <= dt.Rows.Count - 1; i++)
    {
        Chunk imdb = new Chunk("\n " + dt.Rows[i]["FileName"], FontFactory.GetFont("Arial", 7, BaseColor.BLUE));
        imdb.SetAnchor(new Uri(GetAbsoluteUrl("~/Upload/BruddLosPerson/") + Convert.ToString(dt.Rows[i]["FileName"])));
        phrase.Add(imdb);
    }

    cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);
    table.AddCell(cell);
    document.Open();
    document.Add(table);
    document.Close();
    byte[] bytes = memoryStream.ToArray();
    memoryStream.Close();
    Response.Clear();
    Response.ContentType = "application/pdf";
    Response.AddHeader("Content-Disposition", "attachment; filename=Attachment.pdf");
    Response.ContentType = "application/pdf";
    Response.Buffer = true;
    Response.Cache.SetCacheability(HttpCacheability.NoCache);
    Response.BinaryWrite(bytes);
    Response.End();
    Response.Close();
}

Screenshots

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Generate PDF on Button click with Hyperlink from database using C# in ASP.Net

Company

Explore

Follow us

Contact Us