PDF File retrieving from DataBase using asp.net

Question

0.00/5 (No votes)

See more:

C#

string SQL = "SELECT * FROM DPSpdf WHERE intpdfId='" + txtdanceid.Text + "'";
        SqlCommand myCommand = new SqlCommand(SQL, (SqlConnection)Application.Get("DPS"));
        myCommand.Parameters.AddWithValue("@intpdfId", txtdanceid.Text);

        SqlDataReader myReader = myCommand.ExecuteReader();

        if (myReader.Read())
        {
            Response.ContentType = myReader["ContentType"].ToString();
            Response.BinaryWrite((byte[])myReader["strpdfurl"]);

        }

        myReader.Close();
        Response.End();

Where i did mistake?

Posted 6-Feb-11 19:31pm

Rupa1

Updated 6-Feb-11 19:32pm

TweakBird

v2

Add a Solution

3 solutions

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)

Shahriar Iqbal Chowdhury/Galib · Answer 1 · 2011-02-06T19:39:00

Solution 1

Hi,

You are passing inline parameter and command parameter at a time. You need to choose one of them, better choice is passing command parameter instead of inline value.

Please see the modified sql statement below,

C#

string SQL = "SELECT * FROM DPSpdf WHERE intpdfId=@intpdfId";
SqlCommand myCommand = new SqlCommand(SQL, (SqlConnection)Application.Get("DPS"));
myCommand.Parameters.AddWithValue("@intpdfId", txtdanceid.Text);
SqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
   Response.ContentType = myReader["ContentType"].ToString();
   Response.BinaryWrite((byte[])myReader["strpdfurl"]);
}

myReader.Close();
Response.End();

Posted 6-Feb-11 19:39pm

Shahriar Iqbal Chowdhury/Galib

Comments

Rupa1 7-Feb-11 1:51am

sir not coming where i am doing mistake?

Shahriar Iqbal Chowdhury/Galib 7-Feb-11 2:00am

did u debug the code? is data returned from db?

Rupa1 7-Feb-11 4:36am

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

An invalid character was found in text content. Error processing resource 'http://localhost:3055/DPS/testpdf.aspx'. Line 2...

%

ya finally coming error this one sir where i am doing mistake.......

soni uma · Answer 2 · 2011-02-06T19:58:00

Solution 2

Try this code

System.Text.ASCIIEncoding encoding = new System.Text.ASCIIEncoding();
byte[] data = (byte[])myReader["strpdfurl"];
System.Web.HttpResponse Response = System.Web.HttpContext.Current.Response;

Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = myReader["ContentType"].ToString();
Response.AddHeader("content-disposition", "attachment;filename=" + "Test" + ".pdf");
Response.BinaryWrite(data);
Response.Flush();
Response.End();

Posted 6-Feb-11 19:58pm

soni uma

Comments

Rupa1 7-Feb-11 2:33am

string SQL = "SELECT * FROM DPSpdf WHERE intpdfId=@intpdfId";
SqlCommand myCommand = new SqlCommand(SQL, (SqlConnection)Application.Get("DPS"));
myCommand.Parameters.AddWithValue("@intpdfId", txtdanceid.Text);
SqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{

byte[] data = (byte[])myReader["strpdfurl"];
System.Web.HttpResponse Response = System.Web.HttpContext.Current.Response;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = myReader["ContentType"].ToString();
Response.BinaryWrite(data);
myReader.Close();
Response.End();

}
i implemented like this but not showing pdf file sir................

Rupa1 7-Feb-11 2:34am

in binary data coming data but it's not able to write data

soni uma 7-Feb-11 2:41am

I think there is problem in what you store into database. Because the code i give you is working example. Check your code that you store data into binary format.

Rupa1 7-Feb-11 2:45am

ya i gave data field strpdfurl as varbinary(MAX) is it wrong?

soni uma 7-Feb-11 2:51am

yes wrong. If you use Mysql than use LongBlob if Mssql than
use binary or search on that.

soni uma 7-Feb-11 2:56am

Oh i am sorry. If you take varbinary(Max) than it is ok

Rupa1 7-Feb-11 3:00am

shell i keep binary(50) it's ok.......

soni uma 7-Feb-11 3:51am

Try with it.

Rupa1 7-Feb-11 4:35am

ok i keep varbinary(Max) but coming error in output page

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

An invalid character was found in text content. Error processing resource 'http://localhost:3055/DPS/testpdf.aspx'. Line 2...

%

KINGSUJIRAJ · Answer 3 · 2012-12-17T05:27:00

Solution 3

VB

Server Error in '/WebSite2' Application.
ExecuteReader: Connection property has not been initialized.

Posted 17-Dec-12 5:27am

KINGSUJIRAJ