Sql varbinary(MAX) to webbrowser control convert PDF data without create PDF file

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi, Everyone.

I have an issue in convert Varbinary data to WebBrowser. i have upload pdf file in sql server.

Upload Code :

C#

FileInfo f = new FileInfo(ofg.FileName);
FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
Byte[] bytes = br.ReadBytes((Int32)fs.Length);
br.Close();
fs.Close();
if (bytes.Length > 0)
{
        try
        {
        string strQuery = "INSERT INTO DOC_DET (DOC_FILE) VALUES(@DOC_FILE)";
        SqlCommand cmd = new SqlCommand(strQuery);
        cmd.Parameters.Add("@DOC_FILE", SqlDbType.Binary).Value = bytes;
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        con.Open();
        cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            ex.Message.ToString();
        }
        finally { con.Close(); }
}

Now I want to retrieve that Varbinary data into WebBrowser Control

C#

string sql_string = "SELECT DOC_FILE FROM DOC_DET where SEQ_NO = 1;
using (SqlCommand cmd = new SqlCommand(sql_string, con))
             {
                 con.Open();
                 Byte[] bytes = (Byte[])cmd.ExecuteScalar();
                 con.Close();

                 if (drv["DOC_TYPE"].ToString() == ".pdf")
                 {
                     MemoryStream stream = new MemoryStream(bytes);
                     webBrowser1.DocumentStream = stream;
                     webBrowser1.Show();
                 }
             }

What I have tried:

I get This type of unicode display in webbrowser control

output code : "%PDF-1.4 %ÿÿÿÿ 34 0 obj <> stream 2017-10-10T08:36:21Z Nitro Pro 7 (7. 0. 2. 8) 2017-10-10T08:36:22Z 2017-10-10T08:36:22Z application/pdf Nitro Pro 7 (7. 0. 2. 8) uuid:4308e8b5-94b6-42d8-b4f7-4b74a08537af endstream endobj 33 0 obj <> endobj 32 0 obj <> stream xÚl»Â0 E÷~…G˜ÂClˆ„Ô‡¨Äb·ŠDÈIþž¤- ±|}®eGíëCÍ6‚ºŠ3 Eh-£PpI Áƒ:ËÕrhMœªá5½ö•Êææ"õ5·Ö#…ÉO¤ºå¢¼`Ö¸§Åƒ3©'ŽaHm¥.‚$–;˜ÝIP³žô&yÿ¤BÂfPˆqÈËq°qHÁkC¢¹£j»È±ƒí1Ç®°?ýÉõhÿà0VÅõé—åºýIû³î LÉ» Ç©¢–],Ó÷—Þÿÿ*È/é;ÿÿ)jq& endstream endobj 31 0 obj <> stream xÚbÿÿb``h¸ÿÿAýÿý/êïï=ÿÿ> stream xÚ¤ËEPÑ‡»»»»ßÿfü lé¢I'þLägGÅBÇ%$¥¤edåä•”UTÕ¾Œº†¦–¶Ž®ž¾¡‘±‰©YxÌ-,¬mlíì;|ü£“³‹«›»‡g`/oÿÿ²`°d°b°f°òlìì€,G'gÿÿñ™ç endstream endobj 29 0 obj <> stream xÚl[HaÇÿ3»Š†•—¤¥ü†I‹\" i©õAÔ4gIav]u/ë%Q‰RºX£T†‰X„I%]¨O{ñÒÃ– Ò ¤· P(¢— ª·ØíÌª¥äïr~ÿsÎwÎ×Ör² ±è†ÎÊö6}d,ÀM@®Ô4œk|Ó ˆhÍÔÔwVg5ÝX¿EKz•×_?"mŽ¿¥œÀP(.(³’¿[ohëÈ–c<"

Not Show PDF Proper way.

i am not saving pdf file direct Display file

Posted 13-Nov-17 2:06am

RKparmar

Updated 13-Nov-17 12:16pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

an0ther1 · Answer 1 · 2017-11-13T12:16:00

Solution 1

First issue you have is you are using ExecuteScalar. ExecuteScalar returns the first 2033 characters only - refer to MSDN; SqlCommand.ExecuteScalar Method ()[^]

Best option is to return a Datatable/DataSet that contains your data.
Then the code I use which works in IE & Chrome is as follows;

C#

// get the data from the datatable
byte[] bytFile = (byte[])dataTable.Rows[0][VarbinaryFieldName];
// you need to pass the file extension and MIME type & ContentType - hardcoded for brevity
// note the \ characters are to escape the " quote marks
this.Context.Response.ContentType = "\".pdf\",\"application/pdf\"";
// add Header
this.Context.Response.AddHeader("Content-disposition","attachment; filename=filename.pdf");
this.Context.Response.BinaryWrite(bytFile);
Response.End();

Kind Regards

Posted 13-Nov-17 12:16pm

an0ther1

Comments

RKparmar 14-Nov-17 0:12am

Thanks for solution.
But in winform Application there is not contentType Property.
so how can i manage this ?

DataRowView drv = dgvDocument.Rows[e.RowIndex].DataBoundItem as DataRowView;
string sql_string = "SELECT DOC_FILE FROM DOC_DET where SEQ_NO = " + drv["SEQ_NO"];
using (SqlCommand cmd = new SqlCommand(sql_string, con))
{
con.Open();

SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
Byte[] bytes = (Byte[])dt.Rows[0]["DOC_FILE"];
con.Close();

if (drv["DOC_TYPE"].ToString() == ".pdf")
{
MemoryStream stream = new MemoryStream(bytes);
webBrowser1.DocumentStream = stream;
webBrowser1.Show();
}
}

an0ther1 14-Nov-17 18:09pm

From a quick bit of research you cannot do this using Acrobat - it cannot populate a document from a stream. Even if a browser control was used Acrobat never displays from a stream. The stream is saved to Temp Internet Files & then displayed.
Apparently there is a NuGet package that can display a PDF from a stream, do a search for PDFium. I cannot vouch for the functionality nor am I recommending it or endorsing it but it may solve your issue.
Perhaps you need to re-think your design here.

Kind Regards