Category: MS Visual Studio, C#.NET

Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#

February 24, 2012

Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that it would be entirely a C# solution and the program should be able to handle … More Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#

Differenciate or distinguish between outlook attachment and embedded image/signature using property accessor in C#.NET

March 7, 2011

These days, outlook emails are composed in three formats; plain text, html and rtf (rich text format). If an email is in rtf and it has attachments, as well as, embedded image or signature, it poses a problem in outlook automation. When you are reading attachments in an outlook automation program, your program will recognize the … More Differenciate or distinguish between outlook attachment and embedded image/signature using property accessor in C#.NET