[EXCEL]VLOOKUP

[C#] DataRow的刪除


private void SetTestDataTable()
{
DataTable dtTest = new DataTable();
dtTest.Columns.Add("Id",typeof(int));
dtTest.Columns.Add("Name",typeof(string));
dtTest.Rows.Add(1, "aaa");
dtTest.Rows.Add(2, "bbb");
dtTest.Rows.Add(3, "ccc");
dtTest.Rows.Add(4, "ddd");
dtTest.Rows.Add(5, "eee");

foreach (DataRow dr in dtTest.Rows)
{
  if (Convert.ToInt16(dr["id"].ToString()) % 2 == 0)
  {
     dr.Delete(); //標記要刪資的資料列
  }
}

dtTest.AcceptChanges(); //真正移除作業
}



[C#]鍵盤事件-按Enter執行動作及Ctrl+A全選

Button按下ENTER時做的動作

private void Button1_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == (Char)Keys.Enter)
{
TextBox.Text = "";
}
}


TextBox內設定全選功能
private void TextBox_SelectAll(object sender, KeyEventArgs e)
{
if (e.Modifiers == Keys.Control && e.KeyCode == Keys.A)
{
(sender as TextBox).SelectAll();
}
}


[C#]使用xmlWriter建立xml文件

使用xmlWriter建立xml文件


XmlWriter writer = null;

Encoding enc = Encoding.GetEncoding("big5");

XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.OmitXmlDeclaration = false;
settings.NewLineOnAttributes = true;
settings.Encoding = enc;

settings.Indent = true;
settings.IndentChars = ("\t");

spath = @"c:\" + sNow + ".xml";
writer = XmlWriter.Create(spath, settings);
writer.WriteStartElement("body");
writer.WriteElementString("d1", "001");
writer.WriteElementString("d2", "002");
writer.WriteEndElement();
writer.Flush();


[SQL]將日期轉成yyymmdd 的格式

將日期轉成yyymmdd 的格式

SELECT
RIGHT(CAST(1000+ DATEPART(yy, GetDate())-1911 AS CHAR(4)),3) +
RIGHT(CAST(100 + DATEPART(MM, GetDate()) AS CHAR(3)),2) +
RIGHT(CAST(100 + DATEPART(DD, GetDate()) AS CHAR(3)),2) AS ToDay



[C#]常用逸出字元

C#常用逸出字元

跳脫字元	功能說明
\'	單引號
\"	雙引號
\\	反斜線
\a	發出一聲警告
\b	倒退一個字元
\f	Form Feed
\n	換新行
\r	換行並移到最前方
\t	水平方向的Tab
\v	垂直方向的Tab