Profile cover photo
Profile photo
Died Liu
649 followers -
是個好人!!
是個好人!!

649 followers
About
Posts

Post has attachment
Public
[C#] Implement Pivot with LINQ | 用 LINQ 實現 Pivot
Here we will demo how to using LINQ implement Pivot feature in two ways, at first we need a demo data source. 這邊我們要展示如何使用LINQ實作Pivot功能,共兩個方式,首先我們需要一個示範的資料來源。 That table with two brand(both having two products)in four months will be use in this demo. 這個有兩個品牌...
Add a comment...

Post has attachment
Public
政府錯了,機車才是最乾淨的交通工具
[At first,這邊所謂的交通工具,定義為使用燃油(汽油、柴油)的交通工具。] 五月中時,新任總統府祕書長陳菊表示「 新北市機車全台最多 汙染超過深澳電廠 」,言下之意就是機車很汙染就對了。 政府每次都拿最弱勢的機車開刀早就不意外了,之前當上行政院長的賴清德「 抗空汙 」也是先砍機車再說,反正政府與論就是讓民眾覺得機車汙染很大,但事實真的是這樣嗎 ? 錯,在汽油車、柴油車、機車三者中,機車是最乾淨的。 以 平均單輛總排放 來看, 機車不到汽油車的二分之一,更不到柴油車的十六分之一 ,若只看 PM2.5排放...
Add a comment...

Post has attachment
[C#] An fast way to implement Active Directory login to ASP..NET MVC
Although OWIN have a package " Microsoft.Owin.Security.ActiveDirectory " seems can support AD login, but it looks like made for ADFS, and leak document on MSDN so I dunno how to use it on basic AD login, so I decide find other way to implement AD login to M...
Add a comment...

Post has attachment
[PowerShell] Download file and unzip | 下載檔案與解壓縮
PowerShell is an useful command tool on Windows, here I will show how to download file and unzip it. PowerShell是個在Windows上很好用的指令列工具,這邊我將展示如何下載檔案和解壓縮。 Download | 下載 We using Invoke-WebRequest to download file in Windows(like wget in linux), the command like ...
Add a comment...

Post has attachment
從近年立委、議員選舉數據來看女性參政與保障名額
台灣是少數國家將婦女保障名額寫入憲法內的國家,但那是1946年的事了,現在已經過了70多年,在當時看來相當需要的情況下產生的制度,是否在現今環境也需要,我找了近二十年的議員與立委選舉數據作為比較,來看看保障名額在現今社會對於選舉的影響。 資料來源: 中選會資料庫網站 資料選擇:直轄市區域議員1998~2015,區域立委2001~2016,各五筆 會選擇直轄市區域議員與區域立委的原因是因為剛好前者是有保障名額的,而後者沒有,所以用兩者去比較是蠻恰當的。 經整理數據後做成下面兩個圖表。 直轄市區域議員男女比例 在...
Add a comment...

Post has attachment
[C#] OpenCvSharp DNN with YOLO2
On my post " OpenCV DNN speed compare in Python, C#, C++ ", Blaise Thunderbytes asked me to implement pjreddie's YOLO with OpenCvSharp, so that was why this post came out :P Since OpenCV 3.3.1 , DNN moudle supported parse YOLO models, so we can easily using...
Add a comment...

Post has attachment
[MSSQL] Set max server memory using command | 用指令設定伺服器最大記憶體
Few days ago I am testing a issue, set maximum server memory to very low (min limit 128 if you set the value below it) on SSMS, after apply the setting, SSMS pop out error , broken connection from SQL server and can't connect back due to the memory to low c...
Add a comment...

Post has attachment
[C#] VGG Face - Multiple face detection
Last time we tried VGG Face at previous post to display face recognition in one picture, this time we improve it, detect multiple face in one image and recognize them. Here I will use Haar Cascades to do face detection, you can also download other feature-b...
Add a comment...

Post has attachment
[C#] VGG Face CNN descriptor first try
It's time to try face detection since done lot of object detection. At this post, I will try VGG Face Descriptor , test the pre-trained model result, then see what we can do in next phase. As usual, OpenCv Dnn is our model test good friend. This test will b...
Add a comment...

Post has attachment
[C#] OpenCvSharp DNN test with SSD
Last time, we compared different language running in OpenCv DNN at this article OpenCV DNN Speed Test in Python / C# / C++ , this time we can test the newest OpenCvSharp with DNN moudule supported. Let's look the code, most past same as before. var file = "...
Add a comment...
Wait while more posts are being loaded