Windows DeVeDe Development Instructions

This is a checklist of items and actions that must be performed to build/develop DeVeDe on Windows.

First there are several packages that must be installed. All packages are for x86 and not 64bit and all python packages are for version 2.6.*.

C# Database Audit/History Tracking

This is a simple method of history tracking of database changes that in done within in the application. There are other methods to do this including creating triggers within the database itself.

Basically this is one small function that you pass in a dataset and transaction. It loops through each table and each row and column in the table and detects the current state of the row and records it in an audit table.

Despair

Over the past two months I have fixed what should have been two simple problems.

1. When a subpreport was added to a report it would crash when run from the program calling. No matter what was done or changed it would crash but it would run fine in the report designer. The sad fact is that the new subreport was correct but left out of the project. So every time the project was rebuilt it never got copied. Why did this happen? The subreport had a similar name as one that was already included in the project and it got overlooked.

html2chm

C# version of turning a website into a chm file. Requires that html workshop (http://msdn.microsoft.com/library/en-us/htmlhelp/html/vsconhh1start.asp) is installed. If anyone knows of a working open source chm compiler let me know.

Can be used like:
html2chm.Html2chm action = new html2chm.Html2chm();
This will run and prompt you for which website directory and which file in the directory to convert to a chm file.

Or it can be used like this:
bool eachFileAsTopic = true;

Screen Video Capture

I needed a screen video capture software that was free and open source and worked with several different video types. I also wanted the program to record the proper screen colours. So I wrote a small program to do this. It uses mencoder to do the video processing so I will be able to add almost any video format as the output. Current it outputs mpeg/mp3 in an avi container.

MajorSilence2257 Progress Report

I have made some progress with MajorSilence2257. I have it running on Linux.

Screenshot 1
Screenshot 2

Besides SQLite the base data access layer now supports Mssql, MySql, and PostgreSQL. Eventually the maintenance and and GUI will support all four database types.

I am also slowly investigating what is possible with fyiReporting.

Guitar Progress 2

So I can now play Cocaine Cowgirl acceptably good.

List of songs that that I can play but need more practice:
Wonderwall
Feliz Navidad
O Holy Night
I Don't want to miss a thing
Winter wonderland
Have yourself a merry little Christmas
Leaving on a jet plane
I'm Yours

Download Example

Simple download file example. Works with http, https, and ftp. If username and password are required add them to the client using System.Net.NetworkCredential("username", "password").

Use the WebClient DownloadProgressChanged and DownloadFileCompleted events to display percent and start on finish action.

These examples will not work unless you create a winform to go along with them.

VB.net

Imports System.IO
Imports System.Net
Imports System.Threading
Imports System.Text

Public Class Form1

Backgroundworker ReportProgress / Tooltip balloon Messages

The following code is a partial example of using backgroundworker ReportProgress method to access controls from the backgroundworker thread.

The form has one button called Button2. When the form is activated it creates a balloon tooltip message for 5 seconds on it.

These examples will not work unless you create a winform to go along with them.

VB.NET Example

Imports System.ComponentModel
Public Class Form1

    Dim bwCheckForUpdates As BackgroundWorker

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

fyiReporting AsynchronousThreadAbort

I finally figured out what was causing the AsynchronousThreadAbort in MajorSilence2257 when using fyiReporting. Apparently it is caused by setting rdlView.ShowWaitDialog = true. You must set it to false as soon as you create a new instance of the rdlviewer.

rdlView = new fyiReporting.RdlViewer.RdlViewer();
rdlView.ShowWaitDialog = false;

I am assuming this is a bug as I found mention of it on their forums.

Syndicate content