WPF xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"

<Button Grid.Row="1" Content="Load Data" BorderBrush="Black" BorderThickness="10">
<i:Interaction.Triggers>
<i:EventTrigger EventName="Click">
<i:InvokeCommandAction Command="{Binding loadCmd}"/>
</i:EventTrigger>
</i:Interaction.Triggers>
</Button>

查询数据库中所有表表名,行数
SELECT a.name, b.rows 
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC

posted @ 2016-12-31 12:12  FredGrit  阅读(1117)  评论(0编辑  收藏  举报