ASP.NET

1-Feb-13 19:31

I have one form that is built in asp.net containing fields such as name, bank deatils etc.
after filling that online form the user will submit the data and on clicking a button pdf of the whole form filled by the user must be generated.

how can i do this using itext sharp?

also mention another any open source third party tool for this job if available and better than itextsharp??

plz reply ASAP.

Abhishek Pant1-Feb-13 23:31

1-Feb-13 23:31

Convert text into PDF using ASP.NET and C#[^]

hope it helped.

Google-A globe of mirror.

Member 97985414-Feb-13 19:30

4-Feb-13 19:30

k. can u tell me how can we set the background color of the text written in paragraph
as
Paragraph heading=new paragraph("know your client");
doc.add(heading);

I want to color or highlight the text "know your client"

plz reply

Abhishek Pant4-Feb-13 21:36

4-Feb-13 21:36

Know your client

above is demonstration.

<p style="background-color:green;">Know your client</p>

--AP

Member 97985416-Feb-13 17:41

6-Feb-13 17:41

k. Thanks for your continuous replies......
I have written the following code for highlight the text in pdf using itextsharp in asp.net

Know your client

;

but i am getting the error in opening and closing tag of

and

the error is expected ;

and also the text know your client error is doesnot exist in current context.

plz reply as soon as possible.

Abhishek Pant6-Feb-13 18:09

6-Feb-13 18:09

Insert that above code inside the "" like this-
"paste your code here"
on server side.

Thumbs Up | :thumbsup:

Happy coding ! Smile | :)

!

I always prefer good work. Big Grin | :-D

--
vote and accept solution if it helps you.As it may help others when they search here.
--

AP

Member 97985416-Feb-13 19:21

6-Feb-13 19:21

still getting error.
actually i am using asp.net on the click event of a button the pdf will be generated so in code i make a function which will generate a pdf.

errors after placing the code in ""
are:
only assignment,call,increment,decrement and new object expressions can be used as a statement
the name background does not exist in current context.

and many more.

Member 97985416-Feb-13 18:08

6-Feb-13 18:08

one more thing i would like to ask.

the pdf generated using itextsharp will be generated to the client when he/she will completed the form filling process then on clicking the generate pdf button the pdf will be generated regarding the details which are fi;;ed by the client.

now i would like to ask is there any need of licence etc to use for itextsharp commericially purpose.

THANKS IN ADVANCE.

plz reply ASAP.

Abhishek Pant6-Feb-13 19:07

6-Feb-13 19:07

Member 9798541 wrote:
now i would like to ask <layer>is there any need of licence etc to use for itextsharp commericially purpose.

Not a lawyer
but for your Knowledge,Infomation is as below:

iText(iText#)[^] is a free and open source library for creating and manipulating PDF files in C#.version 5.0.0 (released Dec 7, 2009) it is distributed under the Affero General Public License[AGPL] v3.
"Projects that do not want to provide their source code may either purchase a commercial license to iText 5 for an undisclosed price or continue using previous versions of iText under the more liberal license without any changes" that means for using iText v5.0 you have to buy a lisence.However Versions of iText through 4.1.6/4.2.0 were released under the MPL[^] and LGPL[^] licenses, which allowed them to be used in closed-source software projects. check more detail[^]
see terms of use[^]
website for itext[^]

They(itext) pay me from time to time to provide email support. Laugh | :laugh:

----
vote if it helps you.
-----
Abhishek Pant

Display image using handler.ashx what wrong my code

Sandeep Mewara2-Feb-13 0:24

Sandeep Mewara

2-Feb-13 0:24

Member 9798541 wrote:
how can i do this using itext sharp?

You should have tried something before posting it. Start from here: Convert text into PDF using ASP.NET and C#[^]. There are more articles on using iTextSharp here on CP itself, just search for it.

Member 9798541 wrote:
also mention another any open source third party tool for this job if available and better than itextsharp?

Not that I am aware of.

Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Latest Article(s)]:
How to extend a WPF Textbox to Custom Picker
Server side Delimiters in ASP.NET

Michael†Cheong31-Jan-13 20:43

Re: Display image using handler.ashx what wrong my code

31-Jan-13 20:43

XML

aspx
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        DataKeyNames="UserID" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="UserID" HeaderText="UserID" ReadOnly="True"
                SortExpression="UserID" />
            <asp:TemplateField HeaderText="Image">
                 <ItemTemplate>
                    <asp:Image ID="Image2" runat="server" ImageUrl='<%# "Handler.ashx?UserID="+ Eval("UserID") %>' Height="150px" Width="150px"/>
                 </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
_____________________________________________________________________________________________________________________________________________________________

   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

        SelectCommand="SELECT [UserID], [Image] FROM [Users] WHERE ([UserID] = @UserID)">
        <SelectParameters>
            <asp:CookieParameter CookieName="userid" DefaultValue="" Name="UserID"
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
_____________________________________________________________________________________________________________________________________________________________
 public class Handler : IHttpHandler
    {

         string strcon = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        public void ProcessRequest(HttpContext context)
        {

           string imageid = context.Request.QueryString["UserID"];
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            connection.Open();
            SqlCommand command = new SqlCommand("select UserID,Image FROM Users where UserID=" + imageid, connection);
            SqlDataReader dr = command.ExecuteReader();
            dr.Read();
         //   context.Response.BinaryWrite((Byte[])dr[0]);
            context.Response.BinaryWrite((Byte[])dr[dr.GetOrdinal("Image")]);
            connection.Close();
            context.Response.End();
         }
public bool IsReusable
        { ........................ with close properly
_____________________________________________________________________________________________________________________________________________________________
Database

UserID,UserName,Name,Image (UEC80001,Michael,MyName,<Binary data>)(nvarchar(50),nvarchar(50),nvarchar(50),image)
_____________________________________________________________________________________________________________________________________________________________

Richard Deeming1-Feb-13 2:17

Re: Display image using handler.ashx what wrong my code

1-Feb-13 2:17

Apart from the fact that you're not setting the ContentType[^] of the response, you have a SQL injection vulnerability[^] in your code:

string imageid = context.Request.QueryString["UserID"];
...
new SqlCommand("select UserID,Image FROM Users where UserID=" + imageid, connection);

Anyone with access to your site could call Handler.ashx?UserID=1;DELETE FROM Users;, and your code would happily execute two queries: one to select the image for UserID 1, and one to delete all records from the Users table.

Change your code to use a parameterized query:

public sealed class Handler : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        string imageid = context.Request.QueryString["UserID"];
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        // Use "using" blocks to clean up automatically:
        using (SqlConnection connection = new SqlConnection(connectionString))
        using (SqlCommand command = new SqlCommand("SELECT UserID, Image FROM Users WHERE UserID = @UserID", connection))
        {
            // Use a parameterized query to avoid SQL injection:
            command.Parameters.AddWithValue("@UserID", imageid);

            connection.Open();
            using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
            {
                // The image might not exist!
                if (!dr.Read()) throw new HttpException(404, "Image not found.");

                // Add the correct type here:
                context.Response.ContentType = "image/jpeg";
                context.Response.BinaryWrite((byte[])dr[dr.GetOrdinal("Image")]);
            }
        }
    }

    public bool IsReusable
    {
        get { return true; }
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Michael†Cheong1-Feb-13 4:16

Re: Display image using handler.ashx what wrong my code

1-Feb-13 4:16

appreciate Richard reply~

<asp:sqldatasource id="SqlDataSource1" runat="server"
="" connectionstring="<%$ ConnectionStrings:ConnectionString %>" selectcommand="SELECT [UserID], [Image] FROM [Users] WHERE ([UserID] = @UserID)">
<SelectParameters>
<asp:cookieparameter cookiename="userid" defaultvalue="" name="UserID"
="" type="String">
</SelectParameters>

i using the cookie to show the particular user image,so at my side should how to call?

XML

<asp:TemplateField HeaderText="Image">
                 <ItemTemplate>
                    <asp:Image ID="Image1" runat="server" ImageUrl='<%#"Handler.ashx?UserID=1;"+Eval("UserID")%>' Height="150px" Width="150px"/>
                 </ItemTemplate>
            </asp:TemplateField>

ImageUrl='<%#"Handler.ashx?UserID=1;"+Eval("UserID") can i calling by using cookie? at handler cant request cookie @@ other that this handler have other method to display image?

Richard Deeming1-Feb-13 5:36

Re: Display image using handler.ashx what wrong my code

1-Feb-13 5:36

If you want to use a cookie instead of a query-string value, change your Image to:

aspx

<Image ID="Image1" runat="server" ImageUrl="Handler.ashx" Height="150px" Width="150px"/>

and change the start of the ProcessRequest method to:

var cookie = context.Request.Cookies["userid"];
if (null == cookie) throw new HttpException(404, "Cookie not found.");
string imageid = cookie.Value;

NB: You'll still need to use a parameterized command to avoid SQL injection. Cookie values can be altered by the user almost as easily as query-string values.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Michael†Cheong1-Feb-13 5:58

Re: Display image using handler.ashx what wrong my code

1-Feb-13 5:58

ok thx i try ^^ Wink | ;)

Michael†Cheong1-Feb-13 7:03

Re: Display image using handler.ashx what wrong my code

1-Feb-13 7:03

sorry for keep on disturb u and thank u very much Smile | :)

By using ImageUrl="Handler.ashx", can show the data on gridview?

i'm first time using handler XD. for me i set the following code at web.config izit correct?
why it will not previous any error message on browser when my handler code got problem.

XML

<system.web>
      <httpHandlers>
        <add verb="*" path="Handler.ashx" type="ShowImage,System.Web.UI.SimpleHandlerFactory" validate="true" />
      </httpHandlers>

      <urlMappings enabled="true">
        <add url="~/MyProfile.aspx" mappedUrl="~/Handler.ashx"/>
      </urlMappings>
</system.web>

The code should be no problem why still cant function, my connection correct ?

public void ProcessRequest(HttpContext context)
        {

            var cookie = context.Request.Cookies["userid"].Values.ToString();
            if (null == cookie) throw new HttpException(404, "Cookie not found.");
            string imageid = cookie;
         //   string imageid = context.Request.QueryString["UserID"];
            string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;


            // Use "using" blocks to clean up automatically:
            using (SqlConnection connection = new SqlConnection(connectionString))
            using (SqlCommand command = new SqlCommand("SELECT UserID, Image FROM Users WHERE UserID = @userID", connection))
            {
                // Use a parameterized query to avoid SQL injection:
                command.Parameters.AddWithValue("@userID", imageid);

                connection.Open();
                using (SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection))
                {
                    // The image might not exist!
                    if (!dr.Read()) throw new HttpException(404, "Image not found.");

                    // Add the correct type here:
                    context.Response.ContentType = "image/jpeg";
                   // context.Response.BinaryWrite((byte[])dr[dr.GetOrdinal("Image")]);
                    context.Response.BinaryWrite((byte[])dr["Image"]);
                }
            }

        }

Richard Deeming1-Feb-13 8:12

Re: Display image using handler.ashx what wrong my code

1-Feb-13 8:12

The first lines should be:

var cookie = context.Request.Cookies["userid"];
if (null == cookie) throw new HttpException(404, "Cookie not found.");
string imageid = cookie.Value;

If that still doesn't work, try navigating directly to the handler to see what error it produces.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Michael†Cheong8-Feb-13 20:10

Re: Display image using handler.ashx what wrong my code

8-Feb-13 20:10

how to

navigating directly to the handler

Richard Deeming11-Feb-13 1:29