Documentation Delphi TscExcelExport component
Documentation, release notes and many examples of the Delphi VCL TscExcelExport component (in PDF format). The last version of this component works in Embarcadero Delphi 10 Seattle, 10.1 Berlin, 10.2 Tokyo, 10.3 Rio and 10.4 Sydney and it supports all Excel versions from Office 97 to 2019.
.NET - Azure Management Libraries
This article contains a lot of C# .NET examples how to use the Microsoft Azure Management Libraries to automate, deploy, and test cloud infrastructure easily. It includes examples for creating and deleting Azure clouds services, SQL databases, storage, websites, services bus, configuring websites, starting and stopping virtual machines, …
.NET - First look at WCF RIA Services
A few months ago Microsoft released the first preview of .NET RIA Services. This new framework promises to simplify building n-tier Line of Business (LoB) applications by providing patterns, components and tools to build services, query data, handle CRUD operations, resolve concurrency, manage data validation, ... In this first article I will focus on the current limitations and I will offer you some of my workarounds and tips.
.NET - ADO.NET Entity Framework : Metadata extension methods
In addition to my article about querying the metadata of the ADO.NET Entity Framework I have implemented several extension methods that utilize this metadata. This article will describe a set of extension methods which can be used to extend the standard Entity Framework classes (ObjectQuery, EntityObject, ObjectStateManager, ...).
.NET - UI automation with the WPF UIAutomation framework
WPF UIAutomation is a framework from Microsoft to automate Windows applications. In this article I will demonstrate a lot of features (invoking button clicks, focusing controls, entering data, sending keystrokes, subscribing to events, ...) and compare it with the open-source project White.
.NET - UI automation with the White framework
This short article covers the most important features of the open-source White framework and the Microsoft UISpy tool. White can be used for UI automation and my C# .NET application demonstrates how to automate the Windows calculator by sending keystrokes, clicking on buttons and menus, pressing function keys, accessing textboxes, ...
.NET - Modeling PowerToys for Visual Studio 2008
A new version of the open-source PowerToys for the Class Designer and Distributed System Designer has been released. These add-ins provides additional functionality for the Visual Studio Class Designer, such as HTML/XML export, new creation commands, filtering commands, formatting commands, a pan/zoom window, a documentation window, a floating properties window, ... This small post describes how to install it and shows a screenshot which highlights almost all features.
.NET - WPF/Silverlight treeviews and LINQ to SQL
A few examples about .NET WPF applications using LINQ to SQL. This article will describe how to create nice looking treeviews which are populated with data using LINQ to SQL (or LINQ to Entities). Of course resources, templates, styles, datatriggers, value converters, ... will be utilized. Most examples will also work with Silverlight.
.NET - Querying Outlook and OneNote with LINQ
In this article I will describe how I developed two wrapper classes for Outlook and OneNote. These classes can be used to execute LINQ to Objects (.NET 3.5) queries on emails, appointments, tasks, contacts, notebooks, sections, pages, ... So you could call it LINQ to Outlook and LINQ to OneNote.
.NET - LINQ to SQL - part 1
An article about LINQ to SQL (Visual Studio 2008 bèta 2) with a lot of code examples using the Northwind database. Following topics are being covered : querying, view entities, view SQL statements, local data shaping, non-mapped properties in partial entity classes, object Relation Diagram versus Class Diagram, data shaping with non-mapped properties, change tracking, bulk operations.
.NET & Delphi - Freeware and open source developer tools
Overview of all kinds of interesting freeware and open source developer tools, plugins and components for Delphi and .NET (GExperts, DDevExtensions, CFBH, MemProof, GPProfiler, FastMM, JEDI, WinSpector, Yapp, SourceMonitor, LINQ for SQL Visualizer, Cache Visualizer, Reflector, Resourcer, Managed Spy, Snippet Compiler, FxCop, NUnit & DUnit, ColorPic, ...)
Delphi - Configure tools menu with VB scripts
This article shows a way of creating handy extensions for the Delphi Tools menu. Most Delphi developers like to add some extra tools like resource editors, database managers, report designers, ... I have created some Visual Basic scripts (VBScripts, VBS) to open a help file or PDF document, open an URL in your web browser, create a zipped backup file, create a list of PAS files, compile your project with the .NET CF compiler, ...
Version control systems & Visual SourceSafe
Version control systems (VCS) are applications which are used when you need to share source code (Delphi, C++, VB, C#, Java, PHP, HTML, ...) with all members in a team. This article, which is written in Dutch, describes some common principles (check-in, check-out, merging, branching, shelving), it gives an overview of the most popular VCS tools (SourceSafe, SVC, SubVersion, StarTeam, ...) and it provides some info of how to use Visual SourceSafe.
PHP - Automatically select language of visitor
A lot of welcome pages on websites force the user to choose a language. This can be done better by checking the IP-address, resolving the corresponding country and then proposing a language. This article, which is written in Dutch, demonstrates how to build some PHP functions to resolve the user language.
Use data from Outlook in Access
This is a small article, written in Dutch, which demonstrates how to export data from Outlook (agenda, contacts, ...) to Access. In Access these data can be used to build queries or reports.
HTML-Kit - Powerful editor for creating webpages
ACDSee - View, manage and edit photos
ACDSee is one of the best viewers for all kinds of graphical file formats. But this application has a lot more features; it allows you to resize/crop images, convert images to other file formats, rename files in batch, manage albums, view file info and EXIF info, ... In this article, which is written in Dutch, I will show how ACDSee can be used to view, edit and manage photos.
Different kinds of memory cards
This document gives a short summary of the different kinds of memory cards for digital cameras like Compact Flash, SD, MemoryStick, Smart Media, xD, ...
Microsoft Windows 2000 and XP
In this introductory course on Microsoft Windows 2000 and XP, we will focus on the main features of the Windows operating system. We will learn how use the Start menu, the windows and the desktop. Furthermore, we will use Windows Explorer to navigate to files, moving, copying and renaming them.
Delphi - Debugging techniques
Even if you wrote a program in a disciplined, well-structured, careful manner, you will probably still need to debug it to find some bugs. Delphi offers great debugging tools and when you know how to use them, you will surely save a lot of time finding the exact reason of the problem. In this small tutorial I will explain some nice features in Delphi which will help you to debug your programs. Because it is better to avoid bugs, I will also give a few tips to make better programs.
Databases and SQL
This document has been used in a brief training about databases and SQL. It explains all the key concepts of a database (tables, records, fields, keys, referential integrity, indexes, triggers, stored procedures, transactions, ...). Furthermore it gives an overview of the different databases and tools and it gives an introduction to SQL for querying and modifying a database.
History of OOP
This article, which is written in Dutch, gives an overview of the history of OOP (Object Oriented Programming). The first principles were designed in the sixties. After the language Simula, other languages like Smalltalk, ADA, Prolog, C++, Object Pascal, Java and C# followed.
How to use e-mails and internet safely
This article, which is written in Dutch, explains some a few dangers on the internet and describes how you can prevent your PC from being infected with viruses, worms, hoaxes, ...
Icons and filetypes with icons
This article gives an overview of all file formats which can contain icons like ICO, CUR, EXE, DLL, SCR, ICL, OCX, BPL, RES, DCR, ANI, ... files.
Delphi - Copy, move, delete and rename files
In the Windows Shell (= Explorer) several Windows API functions are available to copy, move, delete and rename files. Delphi has some older CopyFile, DeleteFile, MkDir, ... functions but the new Shell functions do have several advantages. This article shows all the Delphi examples you need.
Windows 2000 - System management
This article shows an overview of the system management features of Windows 2000 like logs, shared folders, services, ODBC, performance, ...
Microsoft Word 2000 advanced
Word processing is one of the most widely used computer applications and Microsoft Word 2000 is one of the most advanced word processors. In this course we will work with levels and styles, numbering, headers and footers, footnotes, tables of contents, tables, ... and finally we create custom templates.
Delphi - URLs and emails
In Delphi it is quite easy to open an URL (Universal Resource Location) in your webbrowser by using the WinAPI function ShellExecute (unit ShellAPI). This function is generally used to start applications but it can also be used for calling some internet protocols like MailTo, HyperText Tranfer Protocol (http), File Tranfer Protocol (ftp), News, Telnet, ... This article shows a few examples.
Start programming with Delphi 4.0
In this training course we will gradually get acquainted with the features of the Delphi programming language. We will start with the basic commands and datatypes. Then step by step we will create screens with various components such as buttons, edits, list boxes, checkboxes, ... We will also draw on a canvas and will open images and play videos. This document contains all examples and exercises of the training course.
Delphi - Programming graphics
Delphi offers many features for drawing and painting lines, circles, rectangles, bitmaps, ... and for defining fonts and colors. This article shows several Delphi examples.
Access - Selection queries
This article gives an overview of all operators (>, <=, between, like, and, ...), expressions and functions (count, sum, right, year, len) which can be used to create SELECT queries in MS Access.
Photo editing with Picture Publisher
A training course on general concepts and features of software programs to edit photos. The training will cover topics like how to draw and add text, cropping, contrast and brightness adjustments, sharpening, ... In this course we will use Micrografx Picture Publisher.
Microsoft Word 6.0 advanced
A training course on Microsoft Word 6.0 for advanced users. Topics that are covered are footnotes, tables of contents, tables, images, database links, macros, ...