Case Studies

MSSQL – split value in single column into multiple rows
Problem i have a supplier table that stores supplier email, and the column can store 1 or more email address
MSSQL – Restore a database backup to new database (new name) from TSQL
1. make sure you have exclusive access to the database, means the database is not being used or there are
Copy and Paste screenshot to div using javascript
    <html> <head> <script language="javascript" src="scripts/jquery-3.0.0.min.js"></script> <script> $(document).ready(function(e) { $("#textareaid").bind("paste", function(e){ var items = (e.clipboardData || e.originalEvent.clipboardData).items; console.log(JSON.stringify(items)); //
Javascript Regular Expression
In javascript, we can use regular expression to test if a given string contain the numbers, alphabet, or special characters.
How to convert json string to Dictonary List in C# ?
To convert a JSON string into a Dictionary list, string jsonstring = "[{\"no\":\"1\"}, {\"no\":\"2\"}]"; List<Dictionary<string, object>> items = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<List<Dictionary<string,
How to send email with attachment in C# via Office365.com ?
This aspx code sends email with attachment   <%@ Page Language="C#" AutoEventWireup="true" debug = "true" %> <%@ Import namespace="System.IO" %>
How to connect to MSSQL in C# ?
This aspx code connects to MSSQSL and retrieve data from "product" table.   <%@ Page Language="C#" AutoEventWireup="true"%> <%@ Import namespace="System.IO"
How to generate a random number in C#
This sample code generate 30,000 random 5-character-alphanumeric code in C#. The codes are stored in Hashset to be used for
How to generate QR Code in c# ?
This sample code generate a QR code in C#, and display the QR code on web page Download the library
Free Resources
Sharing a list of online resources, tools available for personal and commercial use. Remember to say thank you to the