WiiSen

Response.Clear();
//要給的實體路徑
Response.WriteFile(physicPath + fileName);
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment;filename=backup.Xls");
Response.Flush();
//刪除臨時文件
System.IO.File.Delete(physicPath + fileName);
Response.End();

使用VS2008 ClickOnce發行程式時，若程式版本號碼沒有更改時，會造成使用者端程式無法更新，
此時必須進行下列步驟，清除ClickOnce的快取資料。

Setp 1. 刪除 C:\Documents and Settings\{User Account}\Local Settings\Apps\2.0 下的所有目錄
Setp 2. 重新啟用 ClickOnce 安裝網頁。

Tips. 若無法看見Local Settings資料夾時，請開啟顯示所有檔案和資料夾選項，如下圖。

Tips 1.如何取得欄位中含有小數(非整數)的資料集

SELECT * FROM EXP_TABLE WHERE COLUMN_A > FLOOR(COLUMN_A)

Tips 2.亂數排序取回的資料集順序

SELECT *, NEWID() AS NEWID FROM EXP_TABLE ORDER BY NEWID

Tips 3.將yyyyMMddHHmmss轉換為DateTime型別

SELECT CONVERT(DATETIME, STUFF(STUFF(STUFF('20120511115720', 9, 0, ' '), 12, 0, ':'), 15, 0, ':'))

持續更新...

/// 

/// 簡易Crystal Report範例 For ASP.NET C#
/// 

public void buildReport(String expType)
{  
  SqlDataAdapter da;
  DataTable dt = new DataTable();
  SqlConnection conn = new SqlConnection(connStr);

  try
  {
   conn.Open();

   da = new SqlDataAdapter("SELECT * FROM REPORT_DATA", conn);

   da.Fill(dt);

   String strFilePath = Server.MapPath("CR001.rpt"); //Application.StartupPath + @"\CR002.rpt";

   String strOutFileName = String.Format("CR{0}.PDF", DateTime.Now.ToString("yyyyMMddHHmmss"));

   ReportDocument Crpt = new ReportDocument();

   // 取得Report檔案
   Crpt.Load(strFilePath);

   // 設定Report資料來源
   Crpt.SetDataSource(dt);
   
   // 設定Report參數
   Crpt.SetParameterValue("ParamName, ","Value");

   // 設定CrystalReportViewer的Report物件來源
   //CrystalReportViewer1.ReportSource = Crpt;

   if(expType.Equals("DISK"))
   {       
    // 寫入實體檔案
    Crpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath(@"PDF_FILES\" + strOutFileName); 
   }
   else if(expType.Equals("RESPONSE"))
   {
    // 輸出串流檔案
    Crpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, strOutFileName);
   }

   ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "JS001", "alert('轉檔完成!!')", true);

   Crpt.Close();
   da.Dispose();
  }
  catch (Exception ex)
  {
   ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "JS001", "alert('" + ex.Message + "')",true);
  }
  finally
  {
   dt.Dispose();
   conn.Close();
   conn.Dispose();
  }
}

/// <summary>
/// 透過SMTP發送信件範例, 以GMail為例 For C#
/// </summary>
private void SendMail()
{
 try
 {
  SmtpClient mailClient = new SmtpClient("smtp.gmail.com");

  //Credentials登陸SMTP服務器的身份驗證
  mailClient.Credentials = new NetworkCredential("user", "password");

  //發件人地址
  MailMessage message = new MailMessage(new MailAddress("Sender<Sender@gmail.com>"));

  //收件人地址
  message.To.Add(new MailAddress("Recever<Recever@gmail.com>"));

  //可以添加多個副本收件人(CC)
  message.CC.Add(new MailAddress("Sender<Sender@gmail.com>"));

  //可以添加多個密件副本收件人(BCC)
  message.Bcc.Add(new MailAddress("Sender<Sender@gmail.com>"));

  //郵件內容
  message.Body = "Mail Test In C#!";

  //郵件主題
  message.Subject = "C# SMTP Mail Send!!";

  //附件
  message.Attachments.Add(new Attachment(@"C:\Attachment.txt")); //添加附件

  mailClient.Send(message);

  MessageBox.Show("寄件成功");
 }
 catch (Exception ex)
 {
  MessageBox.Show("寄件失敗" + "\n\n問題敘述： " + ex.Message);
 }
}

Step 1. 下載Office 2007 SP2 到 D:\
office2007sp2-kb953195-fullfile-zh-tw.exe

Step 2. 將 Office 2007 整個光碟內容複製到 D:\Office2007_SP2

Step 3. 在"命令提示字元"中鍵入
D:\office2007sp2-kb953195-fullfile-zh-tw.exe /quiet /extract:D:\Office2007_SP2\Updates

Step 4. 再將D:\Office2007_SP2 燒錄到光碟或製成ISO檔就完成整合的動作

Tips 1. D:\ 可更換成有充足空間的磁碟
Tips 2. 放在Updates資料夾中的修補程式，在安裝初始化的時候會被套用

Step 1. 在版面配置 > 修改HTML > 修改範本 中在最後面</body>前面加入下列HTML程式碼

<link href='http://alexgorbatchev.com/pub/sh/current/styles/shCore.css' rel='stylesheet' type='text/css'/>
<link href='http://alexgorbatchev.com/pub/sh/current/styles/shThemeDefault.css' rel='stylesheet' type='text/css'/>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shCore.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCpp.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCSharp.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushCss.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJava.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushJScript.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPhp.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPython.js' type='text/javascript'></script> 
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushRuby.js' type='text/javascript'></script> 
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushSql.js' type='text/javascript'></script> 
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushVb.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushXml.js' type='text/javascript'></script>
<script src='http://alexgorbatchev.com/pub/sh/current/scripts/shBrushPerl.js' type='text/javascript'></script>
<script language='javascript'> 
SyntaxHighlighter.config.bloggerMode=true;
SyntaxHighlighter.config.clipboardSwf='http://alexgorbatchev.com/pub/sh/current/scripts/clipboard.swf';
SyntaxHighlighter.all();
</script>

Step 2. 若要新增程式碼在網頁中則使用下列語法, aliases則代表程式語言的別名

<pre class="brush:aliases"> ... code</pre>

Tips. 支援的程式語言如下

SELECT CONVERT(VARCHAR, GETDATE(), 112) AS DATE

1.複製虛擬磁碟(.vdi)
vboxmanage clonevdi {path}\ori.vdi {path}\new.vdi

2.產生新的uuid
vboxmanage internalcommands setvdiuuid {path}\vdisk.vdi

3.把vmdk或vhd轉成vdi
vboxmanage clonehd {path}\ori.vmdk {path}\new.vdi --format vdi

PS.持續更新...