[C#]將文件寫入檔案裡

將文件寫入檔案裡,會自動產生一個檔案，把文字寫入此檔案裡

private bool CreateXml(string xml)

{

try

{

string sNow = DateTime.Today.Year.ToString()

+ DateTime.Now.ToString("MMddHHmmss");

string spath = @"c:\RecXml\RecsXml" + sNow + ".xml";

StreamWriter sw = File.AppendText(spath);

sw.WriteLine(xml);

sw.Flush();

sw.Close();

HisMessage.ShowHint("檔案寫入成功，路徑:" + spath);

return true;

}

catch

{

HisMessage.ShowHint("寫入xml檔時發生錯誤");

return false;

}

}

[SQL]將查詢出來的表格轉成XML-FOR XML

將查詢出來的表格轉成XML-FOR XML

SELECT 1 AS A00,

NhiType AS A01,

1.0 AS A02

FROM NhiICCardRecord

WHERE NhiNo = 1

FOR XML PATH ('REC')

SELECT執行後，就會直接產生可點開的XML

產生的XML內文就是以REC為根目錄，每個欄位就各為TAG

[C#]顯示處理進度狀態-ProgressBar

想要在畫面上顯示處理進度狀態.從工具箱抓出來再加幾小段程式即可

progressBar1.Maximum = 600;
for (int i = 1; i <= 600; i++)
{
sxml = sxml + GetREC(i);
progressBar1.Value = i;
}


[C#]Switch-case用法

Switch-case用法...
因為太常忘記.就放著讓我隨時可以copy

private void Switch_Test(Int16 INo)

{

switch (INo)

{

case 0:

MessageBox.Show("0");

break;

case 1:

MessageBox.Show("1");

break;

case 2:

MessageBox.Show("2");

break;

default :

MessageBox.Show("default");

break;

}

}

[SQL]查詢日期轉為民國年

查詢日期轉為民國年,有時候資料需要前面加0,利用RIGHT與CAST配合


PRINT 'CAST : '
+ 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) +' '
+ RIGHT(CAST(100 + DATEPART(HH, getdate()) AS CHAR(3)), 2) +':'
+ RIGHT(CAST(100 + DATEPART(MI, getdate()) AS CHAR(3)), 2) +':'
+ RIGHT(CAST(100 + DATEPART(SS, getdate()) AS CHAR(3)), 2)

--------print--------------
/**
CAST : 101-01-18 11:28:38
**/


[C#]TextBox全選-Ctrl+A

TextBox全選按Ctrl+A都沒反應....

把下面這串Function套到textbox事件的keydown即可!!

private void TextBox_SelectAll(object sender, KeyEventArgs e)
{
if (e.Modifiers == Keys.Control && e.KeyCode == Keys.A)
{
(sender as TextBox).SelectAll();
}
}

[XML]特殊字元

< 小於	&lt;
> 大於	&gt;
& 和	&amp;
' 單引號	&apos;
" 雙引號	&quot;
斷行符號	&#13

codetest

string Dir = page.Server.MapPath("~/");
StreamWriter sw = File.AppendText(Dir + "input.txt");
sw.WriteLine("第一行");
sw.WriteLine("第二行");
sw.Flush();
sw.Close();