Regular Expressions Cheat Sheet

Regular expressions (regex or regexp) provide a concise and flexible means for matching strings of text, for instance particular characters, words, or patterns of characters. A regular expression is written in a formal language that can be interpreted by a normal expression processor, a program that either serves as a parser generator or examines text and identifies parts that match the provided specification.Regular expressions are used by quite a few text editors, utilities, and … Read more...

Things You Can Do With String.Format In C#

Formatting output string with String.Format is really helpful, and it's been mostly use when you develop application using C# or VB.Net. String.Format firstly released in .NET Framework 1.1. String.Format is for replaces each format item in a specified String with the text equivalent of a corresponding object's value.String.Format overload function:Basic use:As you see the argument that inside the curly braces {0}, is the string format that will replace by the arg0. Which have this … Read more...

[HowTo] Make User Defined Function In SQLite ADO.NET With C#

Sometime we want to make user defined function and use it in our query to the database. In Ms. SQL Server and Oracle DBMS support user defined function, stored procedure and transactional. Since SQLite is zero configuration, serverless and single database file, SQLite doesn't support user defined function (If you don't know what is SQLite and how to use SQLite ADO.Net with C# please refer to this post). User defined function can be made outside of the SQLite that means you make custom function … Read more...

[HowTo] Use SqLite ADO.NET with C#

SQLite is software library written in C that implement self-contained (very minimal support from external libraries), serverless (read/write process directly to database file), cross-platform (run in any Operating System), zero-configuration (no setup/installation needed), transactional (implement serializeable transaction) SQL database engine. SQLite is relatively small, approx 275 KB in size and single database file.For me SQLite is better solution rather than use MS.Access for medium to … Read more...

[HowTo] Run ASP.NET on Linux With Apache Web Server (Mono + Mod_Mono)

Update Sep 18, 2016: This was my very old article. It might not work anymore. And it is obsolete with today technology. Please use other technology rather than using this. Thanks.Mono is an open source project led by Novell (formerly by Ximian) to create an Ecma standard compliant, .NET-compatible set of tools, including among others a C# compiler and a Common Language Runtime. Mono can be run on Linux, BSD, UNIX, Mac OS X, Solaris and Windows operating systems.With Apache mod_mono we can … Read more...