You must Sign In to post a response.
  • Category: ASP.NET

    How To Generate Invoice Bill Values Get From Database Using Asp.Net

    Hi Developers,

    I am Creating a project. Now i want to Generate Invoice Bill.

    The values of the bill should be get from the values which is already stored in the database.

    I am generate a bill without values get from database. But i cant able to generate invoice , the values get from database.

    So anyone of you help me to how i am generate a invoice bill .

    Thanks with
  • #765102
    If you generate Bill Means you can use Reports for this

    Ex: Crystal or RDLC use for this in your invoice Bill.

    Name : Dotnet Developer-2015
    Email Id

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #765104
    how you are generating your invoice ? have you used RDLC ? or any other reporting tool ?
    what is the issue ? what error you have faced ? please elaborate so that we can help you more
    Please put your code for better clearity

    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #765113
    You can export your dataset to excel or some other format, depends which format you are looking for.

    To export data into Excel format:

    System.IO.StringWriter stringWrite=new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htmlWrite=new System.Web.UI.HtmlTextWriter(stringWrite) ;
    System.Web.UI.WebControls.DataGrid dg=new System.Web.UI.WebControls.DataGrid();

  • #765131
    Hi Paul,

    Your question is not clear, if you want to generate Invoice then you need to get the result from your database first then based on your requirement you can show the same in either in reporting tools or in .net application itself that is up to you.

    I didn't seen the question tag in your query, request you to please highlight your query so that we can help you better.

    Give respect to your work, Instead of trying to impress your boss.

    Blog :

  • #765134
    Thanks for all your reply Developers.

    my Invoice bill is should be Like the attached image.
    But the values picked up from the database.

    Thats all .

    Thanks with


    Delete Attachment

  • #765142
    There are lot of way to show the invoices to the customers.

    1. You can use the crystal report to generate the invoice as report.
    2. You can show the invoice as nice webpage and show to the customer
    3. You can create the Invoice as PDF files.
    Normally most of the web application will go for the third way. You can find lot of third part .net libraries to create the PDF files.

    Following is one of the library which I am using. It is open source and very simple to handle it.

    Go through the above PDFSharp step by step PDF creation and generate your invoice.

    By Nathan
    Direction is important than speed

Sign In to post your comments