Generate invoice by fetching data from Database using C# and VB.Net in ASP.Net

Question

hi sir i want to geneate an invoice by using the database valueshow i can generate by using database values help plz

dharmendr · Accepted Answer

Hi fareedfd7Refer below articleGenerate Invoice Bill Receipt PDF from database in ASPNet using C and VBNet

dharmendr · Answer

dharmendr saysDataTable dt  new DataTabledtColumnsAddRangenew DataColumn5                         new DataColumnProductId typeofstring                        new DataColumnProduct typeofstring                        new DataColumnPrice typeofint                        new DataColumnQuantity typeofint                        new DataColumnTotal typeofintdtRowsAdd101 Sun Glasses 200 5 1000dtRowsAdd102 Jeans 400 2 800dtRowsAdd103 Trousers 300 3 900dtRowsAdd104 Shirts 550 2 1100 Replace above with the below code with the articleCDataTable dt  new DataTablestring constring  ConfigurationManagerConnectionStrings34constr34ConnectionStringusing SqlConnection con  new SqlConnectionconstring    using SqlCommand cmd  new SqlCommand34SELECT ProductIdProductPriceQuantityTotal FROM Products34 con            using SqlDataAdapter sda  new SqlDataAdapter

Generate invoice by fetching data from Database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us