Simple Thoughts on Everything

Dictionary<string, string> s = new Dictionary<string, string>();
s.Add("1", "aItem");
s.Add("2", "cItem");
s.Add("3", "bItem");

List<KeyValuePair<string, string>> myList = new List<KeyValuePair<string, string>>(s);
myList.Sort(delegate(KeyValuePair<string, string> firstPair, KeyValuePair<string, string> nextPair)
{
  return firstPair.Value.CompareTo(nextPair.Value);
});

Dictionary<string, string> dic = new Dictionary<string, string>();

foreach (KeyValuePair<string, string> myKey in myList)
{
  dic.Add(myKey.Key, myKey.Value);
}

foreach (KeyValuePair<string, string> a in dic)
{
  Console.WriteLine(a.Key + " " + a.Value);
}

Console.Read();

Dictionary<string, string> s = new Dictionary<string, string>();
s.Add("1", "aItem");
s.Add("2", "cItem");
s.Add("3", "bItem");

var aaaa = s.OrderBy(a => a.Value);
foreach (var a in aaaa)
{
  Console.WriteLine(a.Key + " " + a.Value);
}

Console.Read();

select *
from Orders as o
where ',10254,10257,10261,' like '%,' + ltrim(rtrim(str(o.OrderID))) + ',%'

select *
from Orders as o
where o.OrderID in (10254,10257,10261)

select *
from Orders as o
where o.ShipCity in ('Reims','Bern','Graz');

select *
from Orders as o
where ',Reims,Bern,Graz,' like '%,' + ltrim(rtrim(o.ShipCity)) + ',%'

public class StringPrinter
{
  public void PrintResult(int maxShowNumber)
  {
      int maxPosition;
      if (maxShowNumber % 2 == 1)
      {
          //單數
          maxPosition = (maxShowNumber + 1) / 2;
          PrintUpDown(maxShowNumber, maxPosition, true);
      }
      else
      {
          //表示他是偶數
          maxPosition = (maxShowNumber) / 2;
          PrintUpDown(maxShowNumber, maxPosition, false);
      }
  }
  /// <summary>
  /// 從上到下畫出來
  /// </summary>
  /// <param name="maxShowNumber"></param>
  /// <param name="maxPosition"></param>
  private void PrintUpDown(int maxShowNumber, int maxPosition, bool isOdd)
  {
      bool hook = isOdd;
      //畫出前半部
      int showNumber = 0;
      for (int i = 1; i <= maxPosition; i++)
      {
          showNumber++;
          PrintLine(showNumber, i);
      }
      //畫出後半部
      for (int i = showNumber; i > 0; i--)
      {
          if (hook)
          {
              hook = false;
              continue;
          }
          showNumber++;
          PrintLine(showNumber, i);
      }
  }
  /// <summary>
  /// 畫出每行該出現的數字
  /// </summary>
  /// <param name="number"></param>
  /// <param name="position"></param>
  private void PrintLine(int number, int position)
  {
      string strTemp = string.Empty;
      for (int i = 1; i <= position; i++)
      {
          strTemp = string.Concat(strTemp, number);
      }
      Console.WriteLine(strTemp);
  }
}