在gridview顯示之前，判斷資料並顯示不同狀況

使用SQL的case


一開始先在gridview上的boundfield物件中，設定其datafield來源(為資料表的名稱)

//SELECT CASE ("欄位名")
//  WHEN "條件1" THEN "結果1"
//  WHEN "條件2" THEN "結果2"
//  ...
//  [ELSE "結果N"]
//  END
//FROM "表格名";

       da = new SqlDataAdapter("Select ROW_NUMBER() OVER(ORDER BY Collar_Number DESC) AS Row," +
            "Collar_Number,Transformer_Amount,Switch_Amount,Apply_Date,Collar_User,Authorize_User, " +
            "Case when Authorize = 0 then '未核准' when Authorize = 1 then '核准' END AS Authorize, " +
            "Case when Depot = 0 then '出庫' when Depot = 1 then '在庫' END AS  Depot " +
            "From MaterialCollarManagement Where Authorize = '0'", SqlConn);

// 當 Authorize = 0 會在gridview中datafield來源設定Authorize的物件上顯示 未核准
// 當 Depot = 1 會在gridview中datafield來源設定Depot的物件上顯示 在庫

SQL case 用法可以參考 http://www.1keydata.com/tw/sql/sql-case.html