02
MAR
Microsoft MVP for Azure
All Posts
16
FEB
Azure Fire Alarm by Raspberry Pi and Windows 10 IoT Core
防火是日常生活中非常重要的意识，如果你恰好有Windows 10的设备，比如Lumia，Surface，能及时收到火警是至（mei）关（sha）重（luan）要（yong）的。今天就教大家如何用Microsoft Azure公有云+Windows 10 IoT Core在树莓派上实现一个远程火警系统。阅读这篇文章，你需要的前置知识：Windows 10，UWP的基本开发能力，MVVM基础知识，ASP.NET MVC的基础知识，树莓派、GPIO及逻辑电路的基本知识（也就是大学里的计算机电路），Azure公有云的使用经验……当然，还要有对微软的信仰
04
FEB
Create QR Code in Windows 10 UWP
A year ago, I wrote an UWP application that can generate QR Code. However, at that time, the QR Code library I used was ZXing.Net, the last update for this package was in 2014. Now, time has changed, the author of ZXing.Net seems not to update the package any more. However, we have to move on, so I found a fantastic new library to generate QR Code in .NET applications: QRCoder To use that package, …
29
JAN
Merge Data for N-N Relationship Tables in T-SQL
Recently, I have been organizing my blog data and needed to perform an operation to merge article categories. On my blog, articles and categories have a many-to-many relationship. That is, one article can belong to multiple categories, and one category can contain multiple articles. This is a very typical many-to-many relationship, and I use a many-to-many table with a composite primary key to associate this data. What I need to do is move articles from the "DotNetBeginner" category to the "CSharpAndDotNet" category. However, since some of the articles originally in the "DotNetBeginner" category also belong to "CSharpAndDotNet", directly updating the association table would result in duplicate composite keys, which would cause issues.
22
JAN
Get system font and characters in Windows 10 UWP
There used to be a {x:Static Fonts.SystemFontFamilies} in WPF that can bind to system font list very easy. However, this is gong in UWP! How stupid it is! These days I wrote a character map UWP application, that would use system fonts, so I did some research. In order to get system font in UWP, we must use DirectX. Install these 3 NuGet pacakges into your project: "SharpDX": "3.0.1", " …
05
DEC
How to Remove ListView Default Selection in Windows 10 UWP
A lot of people including me has encounter a problem where on UWP apps, if a ListView control is being data binded, it will get a default selected item like this: It not only will display as selected item, it also fires SelectionChanged event. However, if we want to make ListView clickable, a popular way is to write the SelectionChanged event handler like this: private void StationsList_ …
25
NOV
How to make a modal progress dialog in Windows 10 UWP
Windows 10 Mobile上的文件管理器有这样一个进度指示器，它是一个模态框，不带任何按钮，只有进度条和文本： 今天我琢磨了很久，绕了一些弯路，发现其实要做一个这样的模态进度指示器很简单。只要用ContentDialog就行。 平时我们用ContentDialog有些思维定势，就觉得这个对话框一定要提供按钮给用户操作。其实它是可以不设置任何按钮的，这样就有了初步的雏形： XAML C# private async void BtnSitAndRelax_OnClick(object sender, RoutedEventArgs e) { // show progress await ModalProgressDig.ShowAsync(); } …
03
NOV
UWP App for the Raspberry Pi Azure Surveillance Camera
I wrote a post about Raspberry Pi Surveillance Camera with Linux and Azure, it was using an ASP.NET website for displaying the photos. I made an UWP client App these days, you can download from here https://www.microsoft.com/store/apps/9nblgggzfnv0 (Because WP is already finished, so I don't provide Windows 10 Mobile package) It doesn't allow upload photos, because the photos should all come …
09
OCT
Read AppSettings in ASP.NET Core 2.x
Today, I was rewriting an old ASP.NET MVC5 Demo project to ASP.NET Core, and found that the way we used to read Web.config by ConfigurationManager.AppSettings[] is no longer working. .NET Core has many new ways to achieve this. I picked one that suitable for my project. Here is how I do it. The Classic ASP.NET Code web.config Controller private static CloudBlobContainer GetBlobContainer() …
22
SEP