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...