Path.Combine 中必须是相对路径
最近写了个BUG：Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "/aaa/bbb/c", "dd", "ee")
结果是 /aaa/bbb/c\dd\ee，前面的 AppDomain.CurrentDomain.BaseDirectory 没了。。原因如下：Path.Co...
Sql 查询各组最新数据
列有a、b、time，查出以a分组time为最新的b的数据，组内最新子查询，再joinSELECT
t1.a,
t1.b,
t1.time
FROM
your_table t1
INNER JOIN (
SELECT
a,
MAX("time") AS max_time
FROM
...
WPF EventToCommand
<Window ...
xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
xmlns:cmd="clr-namespace:GalaSoft.MvvmLight.Command;assembly=GalaSoft.MvvmLight.Pl...
SqlServer SqlDataAdapter 用例
SqlDataAdapter 可以实现 UpdateOrInsertpublic void UpdateOrInsertLocStatus(List<RealTimeNearbyLocationCard> status)
{
var dt = new DataTable();
using (SqlConnection conn = new SqlConnectio...