Some differences in Taiwan and Here
The difference experience while dining with the advisor. (not discussing the foods :P)
Category: 學習工作
[Note] Import Data in SQL Server 2005 (匯入資料)
Remeber to check the item “Integration Services” (SSIS) in the install process, or you will fail and get a error message like “product level is insufficient for components” while importing data from txt, excel, etc. files into a SQL server 2005 database. Related: porduct level is insufficient for components
還是改用Regular expression好了
既然都有誤斬忠良的時候… 那 extract html text content 還是用 regular expression 好了，然後再特殊處理一下 <script> 和 <style>… int i, j; i = tb1.Text.ToLower().IndexOf("<script"); while (i >= 0) { j = tb1.Text.ToLower().IndexOf("</script>", i); tb1.Text = tb1.Text.Substring(0, i) + tb1.Text.Substring(j + 9); i = tb1.Text.ToLower().IndexOf("<script"); } i = tb1.Text.ToLower().IndexOf("<style"); while (i >= 0) { j = tb1.Text.ToLower().IndexOf("</style>", i); tb1.Text = tb1.Text.Substring(0, […]
[Memo] 整理一下最近寫程式用到的東西
免得以後要找很麻煩。都是 C# 的程式。 Threading 中作 output 到 textbox 中 delegate void SetTextCallback(TextBox tb, string text); private void SetText(TextBox tb, string text) { if (tb.InvokeRequired) { SetTextCallback d = new SetTextCallback(SetText); this.Invoke(d, new object[] { tb, text }); } else { tb.Text = text; } } Extract text in <body> tag strpage = ""; // Store […]
Wireless Coffee Shops
I love to work in a coffee shop with internet service, especially with a power plug. XD There are many coffee shops in this small town, and all provide wireless internet services. Besides, because of the cold environment of my lab here, I prefer to stay in a coffee shop and work by the wireless […]
July 4th in Santa Cruz
Well, I expect thater are some celebration activities here.
Disabling Close button on Forms
//Used in .net private const int CP_NOCLOSE_BUTTON = 0x200; protected override CreateParams CreateParams { get { CreateParams myCp = base.CreateParams; myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON; return myCp; } }
每逢週四…
就令人火氣大血壓高…
WordPress 與 MySQL 的 Encoding 大混戰…
週五晚上終於順利解決這個煩人的 encoding 問題
M$ SQL Server BCP utility
BCP為M$ SQL Server的一個公用程式(utility)，主要的功能為將大量儲存在檔案中的資料拷貝進入資料庫表格中，或者將資料庫表格中的資料匯出到檔案中，而這些動作都可以透過command line來完成，所以也可以很方便地透過batch file的編寫來當成scheduled job來使用。