Tuesday, April 22, 2014

HP LaserJet Pro 400 M401 韌體更新

使用者告知大量列印時,常常會出現出現問題,想說查查官網有沒有新的韌體和驅動程式,也許更新過後就不會發生,希望啦

官網更新韌體的步驟:
  1. Download the flash firmware updater file from HP.com to the pc desktop.
  2. Turn the printer off and then back on to clear main printer memory.
  3. Double click on the flash firmware update utility file. An HP firmware update window will open.
  4. Select the appropriate MFP in the dialog window. If you assigned a different name to the HP MFP, choose the name that represents the correct printer.
  5. Click on "Send Firmware" when ready to proceed.
  6. The progress bar will begin to move to the right indicating information being transferred.
  7. DO NOT power cycle the product or the pc during this process or the product may become unstable and or unusable without further attention from HP. The flash firmware update can take up to 5 minutes to complete. Please be patient.
  8. During the product flash firmware update, the display on the product control panel will display "Erasing - Programming - Complete - Hewlett-Packard - Ready - Initializing - Ready". Once the download is finished the printer will be in the Ready state.
  9. At the conclusion of the firmware update, the dialog window will show a smiley face. Click on exit.
  10. The flash firmware update process is complete.

Monday, April 21, 2014

SqlDataAdapter Wizard

最近開始學習 C# Winform,找到的網路範例,明明都有看見拖曳 SqlDataAdapter Wizard,就可以直接產生 SqlDataAdapter 控件來使用,但為什麼我的 Visual Studio 內就沒有,原以為是 Express 版沒有,沒想到非 Express 版內也沒有,後來才發現必須手動加入

工具箱 => 任一分類滑鼠右鍵 => 選擇項目

SqlDataAdapter Wizard-1

.NET Framework 元件 => SqlDataAdapter

SqlDataAdapter Wizard-2

就可以在工具箱內看見 SqlDataAdapter,也可以拖曳至工具箱內任一分類

SqlDataAdapter Wizard-3

Friday, April 18, 2014

[SQL] WHERE 和 HAVING 差異

WHERE 和 HAVING 都具有篩選資料的功能,但使用時機和方式,卻是有差異

MSDN WHERE 定義
指定查詢所傳回之資料列的搜尋條件。
MSDN HAVING 定義
指定群組或彙總的搜尋條件。 HAVING 只能搭配 SELECT 陳述式使用。 HAVING 通常用在 GROUP BY 子句中。當未使用 GROUP BY 時,HAVING 的行為會如同 WHERE 子句
WHERE 和 HAVNG 差異
  1. SELECT、FROM、WHERE、GROUP BY 和 HAVING 的 T-SQL 邏輯順序來看,順序分別為
    1. FROM
    2. WHERE
    3. GROUP BY
    4. HAVING
    5. SELECT
    WHERE 在 GROUP BY 之前,而 HAVING 在 GROUP BY 之後
  2. WHERE 無法對彙總欄位進行篩選,但 HAVING 可以
  3. HAVING 通常搭配 GROUP BY 來對彙總資料進行篩選
MSDN 範例

找出金額超過 100,000 的訂單
USE AdventureWorks2012
GO

SELECT 
  SalesOrderID, 
  SUM(LineTotal) AS SubTotal
FROM Sales.SalesOrderDetail
GROUP BY SalesOrderID
HAVING SUM(LineTotal) > 100000.00
ORDER BY SalesOrderID

Thursday, April 17, 2014

寶寶日記-9

寶寶日記-9

Monday, April 14, 2014

紙膠帶

課程問卷禮

紙交代-1

紙交代-2