July 2004 - Posts

Addition of Applications and Forums in WinForm Community

Just had an email conversation with Mike 2 days ago about the addition of 2 new sample applications on the WinForm web site, and he look like solved the technical issue in the forum software and added 2 new forums for IssueVision and FotoVision successfully today. Thanks Mike!

Posted by Colt | with no comments
Filed under:

Installation Procedures

My team was looking for a document management system and the objective of this project is quite simple and in fact it's small scale and target for about 10-20 end users only. We want to have a document management system, starting from scanning paper documents, indexing, editing, archiving, searching and off site storing only, a distributor came to my company and show us a product by the IMR last week.

Firstly, an engineer came in and install the product before demo-ing to us, he insert the CD into one of our fresh machine, click “Next”, and then Ooops, “Next” and then Ooops...

Looking at the installation process, I know this product need to be installed by an administrative account, written on top of .NET Framework v1.1 with the use of MSMQ services, and heavily depends on the driver & ability of the provider of image scanner.

(Auto Detect/Run VS manual installation <-> intelligent product VS embarrassing moment)

Posted by Colt | 3 comment(s)
Filed under:

Microsoft Hong Kong TechEd 2004

The Microsoft Hong Kong TechEd 2004 will be started on 24 Aug next month, and it's a pretty hot topic in the developer communities here lately. Looking at the agenda of this annual event, it look like there're only 7 sessions focus on Development Tools and Technologies, while 5 out of 7 will be presented by Patrick and Bruce (CriticalSales). 

Being a volunteer in INETA for Asia Pacific & Greater China Region, I'm trying to line up the Microsoft HK, INETA, local .NET user groups and other communities and make something happen over there, maybe a BOF, Beta 1 + Express family discussion, casual gathering... whatever technically and financially possible. I met Patrick and Bruce last year, and I really want to organize some user group gathering/events welcoming these star speakers BTW.

Anyway, the local MS staff are having the MGB right now, so I'm still waiting for their good news and time after 21 July.

Posted by Colt | with no comments
Filed under:

OleDbType Enumeration

I work with MS SQL Server most of time in my day time job, while I'm looking for some information about the size for various OleDbType from MSDN web site as I'm working in a Win Form application with MS Access database for one of my client tonight, and accidentially I found this useful KB so I'd like to blog it for future reference. :)

INFO: OleDbType Enumeration vs. Microsoft Access Data Types

List of the Most Common Data Type Mappings

The following table lists the most common data types that are used in Microsoft Access and how these data types relate to the Microsoft .NET Framework data types and to the OleDbType enumeration.

Access Type Name Database Data Type OLE DB Type .NET Framework Type Member Name
Text VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar
Memo LongVarWChar DBTYPE_WSTR System.String OleDbType.LongVarWChar
Number: Byte UnsignedTinyInt DBTYPE_UI1 System.Byte OleDbType.UnsignedTinyInt
Yes/No Boolean DBTYPE_BOOL System.Boolean OleDbType.Boolean
Date/Time DateTime DBTYPE_DATE System.DateTime OleDbType.Date
Currency Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric
Number: Decimal Decimal DBTYPE_NUMERIC System.Decimal OleDbType.Numeric
Number: Double Double DBTYPE_R8 System.Double OleDbType.Double
Autonumber (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid
Number: (Replication ID) GUID DBTYPE_GUID System.Guid OleDbType.Guid
Autonumber (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer
Number: (Long Integer) Integer DBTYPE_I4 System.Int32 OleDbType.Integer
OLE Object LongVarBinary DBTYPE_BYTES Array of System.Byte OleDbType.LongVarBinary
Number: Single Single DBTYPE_R4 System.Single OleDbType.Single
Number: Integer SmallInt DBTYPE_I2 System.Int16 OleDbType.SmallInt
Binary VarBinary* DBTYPE_BYTES Array of System.Byte OleDbType.Binary
Hyperlink VarWChar DBTYPE_WSTR System.String OleDbType.VarWChar

Posted by Colt | 2 comment(s)
Filed under:
More Posts