Create an Excel file in C# without Microsoft Office or Third party plugins

posted in: ASP.NET, C#, Programming, VB.Net, XML 0

How to create an Excel file (XLS / XLSX) in C# without having a copy of Microsoft Office on the server, or other third party plugins installed

Base64 encoding / decoding functions in VbScript / Classic ASP

With the following functions Base64Encode(sText) and Base64Decode(ByVal vCode), You can easly encode/decode a text in/from base64 in VBScript/Classic ASP:

vb.net Bitmap object locks images (impossible to move/delete jpg/gif files) – .Dispose() Method common problem

posted in: ASP.NET, C#, Programming, VB.Net 0

Many people are in trouble and on forums asking why the .Net Bitmap object does not release an image with its .Dispose() method. The Bitmap object (after its destruction too) seems to lock the image file, then we are not … Read More

How to remove accent marks and german umlauts from URLs and Strings in .NET

I wrote two functions in .NET to remove easly any accent and umlaut marks from a string and to get the equivalent non-accented string, this is very useful to normalize URLs; for example, with the StripAccentMarks() method, from “àbcdèéfghìlmnòpqrstùvzäöüÄÖÜ” u’ll … Read More

Multilingual applications with VB.NET

posted in: C#, Programming, VB.Net 2

In this simple tutorial you’ll learn how to manage different languages for a vb.NET application and the simplest way to access programmatically to the string values in the resource compiled files (*.resx) created by Visual Studio; Adding resource files: First … Read More

MySqlHelper VB.NET class – easly execute commands against a MySQL database

posted in: C#, Database, MySQL, Programming, VB.Net 0

Hi all, with the following free .net helper class you can easly execute SQL commands against a MySQL database, execute stored procedures, get or programmatically update tables/DataSet objects and convert to and from MySQL datetime types. Enjoy! 🙂 [sourcecode language=”vb”] … Read More

How to extract text content from tags in VB.Net

With this simple vb.net function You are able to extract content from HTML tags, useful and smart Max 🙂 [sourcecode language=”vb”] Public Function GetTagContent(ByRef html As String, ByVal start_tag As String, ByVal end_tag As String) As String Dim s As … Read More

Updated version of CryptographyHelper class for .NET Framework 4

posted in: C#, Cryptography, Programming, VB.Net 1

This updated version of mine “CryptographyHelper” wrapper/helper class supports .NET Framework 4 . With this vb.net class you can easly encrypt/decrypt strings using a robust symmetric Rijndael algorithm or you can get also MD5 or SHA1, SHA256 hash codes of … Read More

Useful extension methods for the String .Net class and string manipulation, with support of IntelliSense

posted in: C#, Programming, VB.Net 0

Hi to all, I wrote this .NET module that extends String class with useful methods to modify alphanumeric characters and symbols. It fully integrates with the compiler so You are able to recognize extension methods by IntelliSense; in the bottom … Read More

The fastest algorithm in C#/VB.Net to count how many times a value is repeated in a List of items

posted in: C#, Programming, VB.Net 0

The faster way (with the best system performance) to count how many times a particular value is repeated in a List of items, it’s like this [sourcecode language=”vb”] Const chars As String = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz" Dim rnd As New Random() ‘create … Read More