String footer = Server.MapPath("~/Staticpage/Footer.html") //Path of Footer.html File String header = Server.MapPath("~/Staticpage/Header.html") //Path of Header.html File Var studList = GetList() //Get Student List
Html to pdf converter free version 3.2 pdf#
Now, To render data in your view, paste the code below in Index View = "Home Page" Įxport to PDF using (var stud in 6: Create C# code to get required data from database and show it as PDF file to user(note: we have already installed Rotative, which we will be using in this process to convert HTML to PDF) public ActionResult PDFUsingRotativa() StuDet = context.Student_details.ToList() Using (var context = new StudentsEntities())
Here I have created a separate method to get Student list data, here is GetList Method private List GetList() Then the Entity Data Model Wizard will open up where you need to select EF Designer database option. Step 4: Now create Entity framework(ADO.NET) file to connect the project with the database, you would have to add Entity Data Model to your project by right-clicking the "Model" folder in your Solution Explorer and then click on Add and then New Item option of the Context Menu.įrom the Add New Item window, select ADO.NET Entity Data Model and set its Name as "ExportHTML2PDF" and then click Add. (,, , ) VALUES (2, N'Ramesh taurani', N'Class X') (,, , ) VALUES (1, N'Suresh Wahi', N'Class X') )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON Script Date: 3:36:01 PM ******/ĬONSTRAINT PRIMARY KEY CLUSTERED = 'enable'ĪLTER DATABASE SET ANSI_NULL_DEFAULT OFFĪLTER DATABASE SET ANSI_NULLS OFFĪLTER DATABASE SET ANSI_PADDING OFFĪLTER DATABASE SET ANSI_WARNINGS OFFĪLTER DATABASE SET ARITHABORT OFFĪLTER DATABASE SET AUTO_CLOSE OFFĪLTER DATABASE SET AUTO_CREATE_STATISTICS ONĪLTER DATABASE SET AUTO_SHRINK OFFĪLTER DATABASE SET AUTO_UPDATE_STATISTICS ONĪLTER DATABASE SET CURSOR_CLOSE_ON_COMMIT OFFĪLTER DATABASE SET CURSOR_DEFAULT GLOBALĪLTER DATABASE SET CONCAT_NULL_YIELDS_NULL OFFĪLTER DATABASE SET NUMERIC_ROUNDABORT OFFĪLTER DATABASE SET QUOTED_IDENTIFIER OFFĪLTER DATABASE SET RECURSIVE_TRIGGERS OFFĪLTER DATABASE SET DISABLE_BROKERĪLTER DATABASE SET AUTO_UPDATE_STATISTICS_ASYNC OFFĪLTER DATABASE SET DATE_CORRELATION_OPTIMIZATION OFFĪLTER DATABASE SET TRUSTWORTHY OFFĪLTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION OFFĪLTER DATABASE SET PARAMETERIZATION SIMPLEĪLTER DATABASE SET READ_COMMITTED_SNAPSHOT OFFĪLTER DATABASE SET HONOR_BROKER_PRIORITY OFFĪLTER DATABASE SET RECOVERY SIMPLEĪLTER DATABASE SET PAGE_VERIFY CHECKSUMĪLTER DATABASE SET DB_CHAINING OFFĪLTER DATABASE SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )ĪLTER DATABASE SET TARGET_RECOVERY_TIME = 0 SECONDS IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))ĮXEC. ( NAME = N'Students_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS2\MSSQL\DATA\Students_log.ldf', SIZE = 1024KB, MAXSIZE = 2048GB, FILEGROWTH = 10%)ĪLTER DATABASE SET COMPATIBILITY_LEVEL = 110
( NAME = N'Students', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS2\MSSQL\DATA\Students.mdf', SIZE = 3072KB, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) You can create database with dummy database with Demo table and Data using the below scripts (using SQL server 2012 or above) USE Step 3: Now we need to connect our project with database, so get your database from SQL server and connect it with your MVC project, here I am using my local database "Students", with table "Student_details" here is the snapshot of database, with its current dummy data We can find the rotativa reference under the reference, with a separate folder named ‘Rotativa’ with the following contents.Īnother folder named App_Browsers which has the contents required by the package Rotativa. Step 2: Now you have generated basic MVC file template, now Right-click on your project(In Solution Explorer pane) ->Manage Nuget packages->In "Nuget package manager window" select the "Browse" tab, then search for "Rotativa", Select and click install. Select MVC template to generate basic HomeController and other details. Step 1: Create a project in your Visual Studio(2017 in my example), by opening Visual Studio and clicking "File"-> "New"-> "Project". It is actually derived a version of wkhtmltopdf which converts HTML to pdf.
Let's start with Rotativa to export HTML to pdf in MVC.Rotativa makes it very easy to generate pdf from an HTML. In this article, I will explain different ways to export HTML to PDF in asp.net MVC C# using Rotativa and iTextSharp, step by step with an example.
0 kommentar(er)
