pdf viewer c# winform: Add photo pdf Library application component .net html web page mvc aspEasyPDF14-part234

Add

DB Text

Function explain

Name

Add DB Text

Parameters

Name as String, X as Double , Y as Double , Width as Double , Connection as String , Field d as

String

Result

(none)

From version 3.20

" Enterprise feature "

Adds a database field from the given connection to the report. If it's linked to the detail band then it will print the give

field for each record. The AddDBText gets it's primary function from the

AddTextWidth

function so it works in the

same way.

Script support

Adds support for the [name] _OnPrintBefore and [name] _OnPrintAfter event. The result of the _OnPrintBefore is taken

to the final output and the first parameter contains the field value. See the script section on the easyReportPDF help

file.

Example

' Create the component

set PDF = server.createobject(" aspPDF.EasyPDF ")

' Enterprise version

PDF. SetReportPage

PDF. Page "A4", 0

PDF. AddDBBand 20, 15

PDF. AddDBConnection " connection4", "Driver={MSSQL};Host=192.168.0.7;Database=Northwind;User ID=sa ",

PDF. SetDBSQL " connection4 ", " SELECT I.* FROM Invoices I "

PDF. SetDBBandActive 20

PDF. AddDBText " field6 ", 152, 8, 37, " connection4 ", " OrderID "

PDF. RenderReport

PDF. Save Server.MapPath(" orders.pdf ")

' destroy it

set PDF = nothing

See Also

SetParameter

SetDBSQL

- aspEasyPDF -

143 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

VB.NET Image: Image Scaling SDK to Scale Picture / Photo

To help you know more about this VB.NET image scaling control add-on, we scaling control SDK API, developer can only scale one image / picture / photo at a

add a picture to a pdf file; add a picture to a pdf document

C# Image: How to Add Antique & Vintage Effect to Image, Photo

this C#.NET antique effect creating control add-on is widely used in modern photo editors, which powerful & profession imaging controls, PDF document, tiff

add picture to pdf in preview; adding image to pdf

Add

Script

Function explain

Name

Add Script

Parameters

Script as String

Result

(none)

From version 3.20

" Enterprise feature "

Sets the script of the report to manage dynamic contents while rendering it.

To add multiple script contents to the report without overriding it you should add at the first line the following charset:

<+>

aspEasyPDF uses Pascal scripting technology to bring fast running process, using events and object oriented

programming in the report. Is very easy to use and if you wish to learn how to use it see the easyReportPDF help file.

The compilation process of script takes when you issue the RenderReport function. You should always check if the

renderReport returns false, if it does then check the LastError to see if you have an error on your script. Use always the

VisualEasyPDF to code script inside aspEasyPDF, you may use breakpoints to debug it and you will see immediately

any compilation error with just pressing a button.

Supported events:

* For all field, text, graphic and shape object it supports the _OnPrintBefore and _OnPrintAfter

* At this moment it only supports the detail band; Details_OnPrintBefore if returns false then it will not print the detail

content of the recordset that points.

Internal commands

Script syntax which comunicates with aspEasyPDF

Methods

Description

DBDataSet

Returns the TDataSet object from the connection given:

DBField

Returns the TField object from the connection and field given.

getPropObj

This function works like the aspEasyPDF

GetPropObj

getProperty

This function works like the aspEasyPDF

GetProperty

SetPropObj

This function works like the aspEasyPDF

SetPropObj

SetProperty

This function works like the aspEasyPDF

SetPropety

Variables

Description

WEB_APP

Returns or sets the Web_APP

variable

PosXCursor

Returns or sets the PosXCursor

var, which is the actual position of the X Cursor on the

document.

PosYCursor

Returns or sets the PosYCursor

var, which is the actual position of the Y Cursor on the

document.

PageNumber Returns the PageNumber

variable

PageCount

Returns PageCount

variable

Constants

Description

- aspEasyPDF -

144 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

VB.NET Image: Image Resizer Control SDK to Resize Picture & Photo

VB.NET Image & Photo Resizing Overview. The practical this VB.NET image resizer control add-on, can powerful & profession imaging controls, PDF document, image

how to add image to pdf acrobat; add picture to pdf reader

VB.NET Image: How to Save Image & Print Image Using VB.NET

NET programmers save & print image / photo / picture from NET method and demo code to add image printing printing multi-page document files, like PDF and Word

how to add image to pdf document; add image pdf

Version

Returns Version

variable

NVersion

Returns NVersion

variable

Example

On this sample set a simple script which checks the Type field from connection4, if it's 1 then sets the field8 object to

the X position at 50px if not, then it sets the X positions to 96px. Check that the setPropObj uses 605 constant identifier

which is the same as the aspEasyPDF; csPropObjPosX.

scr = " function details_onprintbefore; "

scr = sc r + "var "

scr = sc r + " x : integer; "

scr = sc r + "begin "

scr = sc r + " if DBField('Connection4.Type').asInteger = 1

then "

scr = sc r + " begin ");

scr = sc r + " setPropObj('field8', 605, '50' ); "

scr = sc r + " end "

scr = sc r + " else "

scr = sc r + " begin "

scr = sc r + " setPropObj('field8', 605, '96'); "

scr = sc r + " end ;"

scr = sc r + "end; "

PDF. SetScript src

- aspEasyPDF -

145 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

VB.NET Image: Tutorial for Flipping Image Using Our .NET Image SDK

version of .NET imaging SDK and add the following becomes a mirror reflection of the photo on the powerful & profession imaging controls, PDF document, tiff

add picture to pdf form; adding an image to a pdf in acrobat

C# PDF remove image library: remove, delete images from PDF in C#.

Support removing vector image, graphic picture, digital photo, scanned signature, logo, etc. Remove Image from PDF Page Using C#. Add necessary references:

add an image to a pdf with acrobat; add photo to pdf file

Add

Text Field

Function explain

Name

Add TextField

Parameters

Name as String, X as Double , Y as Double , Width as Double , Text t as

String

Result

(none)

From version 3.20

" Enterprise feature "

Same function as the

AddTextWidth

but adds the Name tag to the object. This way we can change the properties of

the object while rendering the report trough the script section. See the script section on the easyReportPDF help file to

known more about changing dynamically the object properties.

Script support

Adds support for the [name] _OnPrintBefore and [name] _OnPrintAfter event. The result of the _OnPrintBefore is taken

to the final output. See the script section on the easyReportPDF help file.

It also adds some reserved syntax;

Reserved Syntax

Band

Type

@Date()

Prints the actual date

@DateTime()

Prints the actual date time

@MAX( conneciton.field

)

Prints the maximum amount of the given connection and field notation

@MIN( conneciton.field ) Prints the minimum amount of the given connection and field notation

@Page()

Prints the actual page

@SUM( conneciton.field

)

Prints the sumatory amount of the given connection and field notation

@Time()

Prints the actual time

Example in C#

<% @Page Language="C#" %>

<% @Import Namespace="System" %>

<% @Import Namespace="System.Text" %>

<% @Import Namespace="System.Web" %>

<% @Import Namespace="aspPDF" %>

// *****************************************************************

// Remember to add a COM+ Reference of aspEasyPDF, this will create

// the Interop dll; Interop.aspPDF.dll for using it in C#

// *****************************************************************

// #$#Author#$#

// #$#Date#$#

// #$#VEPVER#$#

// VEP_BEGIN_AUTO_CODE

PDF. SetScript(" <+>function details_onprintbefore; ");

- aspEasyPDF -

146 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

PDF. SetScript(" <+>var ");

PDF. SetScript("<+> x : integer;");

PDF. SetScript(" <+>begin ");

PDF. SetScript("<+> if DBField('Type').asInteger = 1 then");

PDF. SetScript(" <+> begin ");

PDF. SetScript(" <+> setPropObj('field8', 605, '50' ); // Text X Position ");

PDF. SetScript(" <+> setPropObj('field8', 100, 'F2' ); // Font F2 is for a bold font ");

PDF. SetScript("<+> setPropObj('field8', 104, '1' ); // Underline");

PDF. SetScript("<+> setPropObj('field9', 611, '0' ); // Set invidible the quantity");

PDF. SetScript("<+> setPropObj('field32', 611, '0' ); // Set invidible the price field");

PDF. SetScript("<+> end");

PDF. SetScript("<+> else");

PDF. SetScript("<+> begin");

PDF. SetScript("<+> setPropObj('field8', 605, '96' ); // Text X Position");

PDF. SetScript("<+> setPropObj('field8', 100, 'F1' ); // Font");

PDF. SetScript("<+> setPropObj('field8', 104, '0' ); // Underline off");

PDF. SetScript("<+> setPropObj('field9', 611, '1' ); // Quantity visible");

PDF. SetScript("<+> setPropObj('field32', 611, '1' ); // Price visible");

PDF. SetScript("<+> end;");

PDF. SetScript("<+> Result := True;");

PDF. SetScript("<+>end;");

private void DoPageVEP_1(aspPDF.EASYPDF PDF)

{

PDF. SetReportPage ();

PDF. Page("A4", 0);

PDF. AddDBBand (5, 135);

PDF. AddDBBand (20, 15);

PDF. AddDBBand (35, 43);

PDF. AddDBConnection (" connection4 ", "Driver={MYSQL};Host=192.168.0.2;Database=""MITGestion"";Port=3306;User

ID=root;Password=", 20);

PDF. SetDBSQL ("connection4", "SELECT f.*, f.Fabricacion_ID, f1.*, f1.Fabricacion_LineaID_SUB, f1.Posicion, f1.Tipo,

(f1.Precio * f1.Cantidad) PrecioToal FROM fabricaciones f, fabricaciones_detalles f1 WHERE

f.Fabricacion_ID=f1.Fabricacion_ID AND f.Fabricacion_ID = :FabricacionID AND (f1.Tipo = 1 OR f1.Tipo = 2 OR f1.Tipo =

4) ORDER BY f1.Fabricacion_LineaID, f1.Posicion ");

PDF. SetFont("F1", 12.5, "# 000000 ");

PDF. AddDBText(" field6 ", 392, 74, 107, " connection4 ", " Fabricacion_ID ", 0);

PDF. SetFont("F1", 10, "#000000");

PDF. SetDBBandActive(20);

PDF. AddDBText("field7", 8, 8, 89, "connection4", " Producto_ID ", 0);

PDF. AddDBText("field8", 96, 8, 169, "connection4", " Texto ", 0);

PDF. SetProperty (102, 1);

PDF. AddDBText("field9", 288, 8, 42, "connection4", " Cantidad ", 0);

PDF. SetPropObj("field9", 905, "%.2n");

PDF. SetFont("F1", 20, "#000000");

PDF. SetDBBandActive(5);

PDF. AddTextPos (160, 32, "ESCANDALLOS COMPLETOS");

PDF. SetFont("F1", 12.5, "#000000");

PDF. SetProperty (102, 0);

PDF. AddDBText(" field31 ", 504, 8, 82, " connection4 ", " PrecioToal ", 0);

PDF. SetPropObj(" field31 ", 905, "%.2n €");

PDF. AddDBText(" field32 ", 408, 8, 62, " connection4 ", " Precio ", 0);

PDF. SetPropObj(" field32 ", 905, "%.2n €");

PDF. SetDBBandActive(35);

PDF. AddLine(0, 3, 600, 3);

PDF. SetFont(" F1 ", 12.5, "# 000000 ");

PDF. SetDBBandActive(5);

PDF. AddTextPos (32, 74, " Referencia :");

PDF. AddTextPos (24, 90, " Descripción :");

PDF. AddDBBand (6, 6);

PDF. AddDBBand (34, 23);

- aspEasyPDF -

147 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

PDF. SetFont("F2", 10, "#000000");

PDF. SetDBBandActive(35);

PDF. SetProperty (102, 0);

PDF. AddTextField ("text8", 40, 16, 49, " @Page() ");

PDF. SetFont("F2", 10, "#000000");

PDF. SetDBBandActive(34);

PDF. AddTextField ("text33", 392, 12, 196, " @Sum(connection4.PrecioToal) ");

PDF. SetPropObj("text33", 905, "%m");

PDF. SetDBBandActive(5);

PDF. AddDBGraphic ("graphic36", 496, 11, "URL", "file:///K:\Archivos de Dibujo\MITData\logo_petit.bmp");

rdrrprt = PDF. RenderReport();

}

// VEP_END_AUTO_CODE

private void Page_Load(Object sender, EventArgs e) {

aspPDF.EASYPDF PDF = new aspPDF.EASYPDF();

DoPageVEP_1( PDF );

// SaveVariant is a function that just works for aspEasyPDF 2.1

Response.Clear();

Response.ContentType="application/pdf";

Response.AddHeader( "content-disposition","attachment; filename=MyPDF.PDF");

Response.BinaryWrite( (byte[]) PDF.SaveVariant());

}

</script>

- aspEasyPDF -

148 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

RenderReport

Function explain

Name

RenderReport

Parameters

(none)

Result

Result as Boolean

From version 3.20

" Enterprise feature "

When you have ended all report definition and you wish to run it and create all the report pages you should call the

RenderReport. This function will check the script for error, then create all connections and open all queries assigned to

the report and the draw the report.

You should always look for the return result of this function, if doesn't succeed then you will check the LastError

message to check which was the error.

After the report is rendered the same function will close all connections and wait for a new RenderReport call. If you

issue another report definition then all structure will be empty to accommodate the new report.

You may render reports as many times as you want, it will create numerous pages. Then after finishing you can move

to any page and add any information as it was an aspEasyPDF page.

After the report has been render you should save the PDF or redirected trough the browser with the appropriate

command.

Example

' Create the component

set PDF = server.createobject(" aspPDF.EasyPDF ")

' Enterprise version

PDF. SetReportPage

PDF. Page "A4", 0

PDF. AddDBBand 5, 100

PDF. AddDBBand 20, 15

PDF. AddDBBand 35, 100

PDF. AddDBConnection " connection4", "Driver={MSSQL};Host=192.168.0.7;Database=Northwind;User ID=sa ",

PDF. SetDBSQL " connection4 ", " SELECT I.* FROM Invoices I "

PDF. SetDBBandActive 20

PDF. SetFont " F1 ", 10, "# 000000 "

PDF. AddDBText " field5 ", 8, 8, 137, " connection4 ", " CustomerName "

PDF. AddDBText " field6 ", 152, 8, 37, " connection4 ", " OrderID "

PDF. AddDBBarCode " graphic9 ", 304, 0, 10, 5, " connection4 ", " OrderID "

PDF. RenderReport

PDF. Save Server.MapPath(" orders.pdf ")

' destroy it

set PDF = nothing

- aspEasyPDF -

149 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

- aspEasyPDF -

150 / 325

Generated with aspEasyPDF library using demo sample CHM2PDF

Documents you may be interested

pdf viewer c# winform : Add photo pdf Library application component .net html web page mvc aspEasyPDF14-part234