Display PDF file In GridView using C# and VB.Net in ASP.Net

Question

sirI want to display multiple pdf file from the SQL database in iframe opr embed without any use of linkbutton or hyperlinkSo how can i do plz give me some idea about this

Andrea · Accepted Answer

Hi kats9993Please try the followingDisplay data from database in TextBox using SqlDataReader in ASPNetIt might help youCheers Andrea

BigHeart · Answer

Add ASHX file to your solution and call this page bind each pdf id to each frame string bindtoFrame  34Fileashxid34  idToStringpublic void ProcessRequestHttpContext contextstring id  contextRequestQueryString34id34ToStringstring sConn  SystemConfigurationConfigurationManagerConnectionStrings34ConnectionString34ToStringSqlConnection objConn  new SqlConnectionsConnobjConnOpenDataTable file  new DataTableSqlCommand cmd  objConnCreateCommandcmdCommandType  CommandTypeTextcmdCommandText  34SELECT  FROM AttachmentTable where ID  3934 id 343934SqlDataAdapter da  new SqlDataAdaptercmddaFillfileobjConnClosecmdDisposeif fileRowsCount gt 0DataRow row  fileRows0string name  stringrow34Filename34string contentType  stringrow34FileExt34Byte data  Byterow34Attachment34int FileSize  ConvertToInt32row34Filesize34ToStringS

Indresh · Answer

Hi  kats9993I have created sample code by refering the below article which fullfill your requirementConvert Binary data to PDF file in C and VBNetHTMLltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34 OnRowDataBound34GridView1RowDataBound34gt    ltColumnsgt        ltaspBoundField DataField34Id34 HeaderText34File Id34 gt        ltaspBoundField DataField34Name34 HeaderText34File Name34 gt        ltaspTemplateField ItemStyleHorizontalAlign34Center34gt            ltItemTemplategt                ltaspLiteral ID34ltEmbed34 runat34server34 gt            ltItemTemplategt        ltaspTemplateFieldgt    ltColumnsgtltaspGridViewgtCprotected void PageLoadobject sender EventArgs e    if IsPostBack            thisBindGrid    private void BindGrid    string constr  ConfigurationManagerConnectionStrings34constr3

Display PDF file In GridView using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us