akhuang

List<string> list=new List<string>();
		 	list.Add("k");
		 	list.Add("b");
		
			Console.WriteLine(string.Join(",",list));
			
			List<Student> listStu= new List<Program.Student>();
			listStu.Add(new Student(){ Name="p" });
			listStu.Add(new Student(){ Name="p2" });
			

akhuang

update DICT_COUNTRIES set Country_Seq=(select count(*) from DICT_COUNTRIES t2 where t2.COUNTRY_ID<=t1.COUNTRY_ID )
from DICT_COUNTRIES t1 

akhuang

https://www.digitalocean.com/community/tutorials/how-to-deploy-jekyll-blogs-with-git

#yum install git
#curl -L https://get.rvm.io | bash -s stable --ruby=2.0.0
#gem install jekyll
#jekyll new blog
#cd blog
#git init --bare 
#cd hooks
#touch post-receive

akhuang

using System;
using System.Collections.Generic;
using System.IO;
using System.Collections;
using System.Text;

public class MyClass
{
    public	static string FOLDERPATH=@"D:\Temp\UpdateScript\";
	public static string  ExcludeFolder=".svn";

akhuang

Allows adding custom data as any number of data parameters:

<li><a data-person="Zim" data-toggle="modal" data-target="#person-modal"></a></li>
<li><a data-person="Dib" data-toggle="modal" data-target="#person-modal"></a></li>
...
Use the show event to inject your custom data into the modal.

    $('#person-modal').on('show', function (event) {
        name = $(this).data('modal').options.person
        $(this).find('.person').html(name)

akhuang

################################################################################################################################
#
# Script Name : SmoDb
# Version     : 1.0
# Author      : Vince Panuccio
# Purpose     :
#			  This script generates one SQL script per database object including Stored Procedures,Tables,Views, 
#			  User Defined Functions and User Defined Table Types. Useful for versionining a databsae in a CVS.
#
# Usage       : 

akhuang

DataTable table = new DataTable();
  		table.Columns.Add(new DataColumn("Column #1"));
			table.Columns.Add(new DataColumn("Column #2"));
			table.Rows.Add(1, 2);
			table.Rows.Add(11, 22);
			table.Rows.Add(111, 222);
			
			foreach (var column in table.Columns)
			{
				DataColumn dc = column as DataColumn;

akhuang

	string s = "adadf(深圳)(em.test@163.net.cn) 是我的email地址";
	//it's wrong; when target is "test.test@mail.com, the output is test@mail.com
  	//string ptn = @"[a-z\d_\-]+@[a-z\d_\-]+(.[a-z\d_\-]+)+"; 
  	string ptn=@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*";
		
	Regex reg = new Regex(ptn, RegexOptions.IgnoreCase);
	Match m = reg.Match(s);
		
	Console.WriteLine(m.ToString());

akhuang

List<int> list=new List<int>();
  	int i=1;
		while(i<=100)
		{
			list.Add(i);
			i++;
		}
		
		foreach(int j in list)
		{

akhuang

/****** Object:  Table [dbo].[Fruit]    Script Date: 09/22/2013 15:53:26 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fruit]') AND type in (N'U'))
DROP TABLE [dbo].[Fruit]
GO
/****** Object:  Table [dbo].[Fruit]    Script Date: 09/22/2013 15:53:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Fruit]') AND type in (N'U'))