Skip to content

Instantly share code, notes, and snippets.

public static bool IsConnectedToInternet()
{
ConnectionProfile connectionProfile = NetworkInformation.GetInternetConnectionProfile();
return (connectionProfile!=null && connectionProfile.GetNetworkConnectivityLevel() == NetworkConnectivityLevel.InternetAcces);
}
<VSTemplate Version="3.0.0" xmlns="http://schemas.microsoft.com/developer/vstemplate/2005" Type="Item">
<TemplateData>
<DefaultName>Encrypted Config.encryptedconfig</DefaultName>
<Name>Encrypted Config</Name>
<Description>Encrypted Config</Description>
<ProjectType>CSharp</ProjectType>
<SortOrder>10</SortOrder>
<Icon>__TemplateIcon.ico</Icon>
</TemplateData>
<WizardExtension>
<VSTemplate Version="3.0.0" xmlns="http://schemas.microsoft.com/developer/vstemplate/2005" Type="Item">
<TemplateData>
<DefaultName>app.encryptedconfig</DefaultName>
<Name>Encrypted Config</Name>
<Description>Encrypted Config</Description>
<ProjectType>CSharp</ProjectType>
<SortOrder>10</SortOrder>
<Icon>__TemplateIcon.ico</Icon>
</TemplateData>
<WizardExtension>
from p in Portfolio
.Expand("Sectors")
.Expand("Technologies")
.Expand("Customers")
select p
create sequence SampleSequence as int
start with 1 -- Start with value 1
increment by 1-- Increment with value 1
minvalue 0 -- Minimum value to start is zero
maxvalue 100 -- Maximum it can go to 100
no cycle -- Do not go above 100
cache 50 -- Increment 50 values in memory rather than incrementing from IO
SELECT NEXT VALUE FOR dbo.SampleSequence AS seq_no;
@wullemsb
wullemsb / SQL 2012 Pagination
Created January 18, 2013 19:18
SQL Server 2012 Pagination
SELECT * FROM PRODUCTS
ORDER BY PRODUCTNAME
OFFSET 10 ROWS
FETCH NEXT 10 ROWS ONLY
<ComboBox x:Name="Categories" Grid.Column="2" Height="30" Width="300" >
<ComboBox.ItemTemplate>
<DataTemplate>
<Button
caliburn:Message.Attach="Filter(Category)">
<TextBlock x:Name="Category" Margin="0,0,0,10" Text="{Binding Category}"/>
</Button>
</DataTemplate>
</ComboBox.ItemTemplate>
</ComboBox>
<ComboBox x:Name="Categories" Grid.Column="2" Height="30" Width="300" >
<ComboBox.ItemTemplate>
<DataTemplate>
<Button
caliburn:Action.TargetWithoutContext="{Binding ElementName=pageRoot, Path=DataContext}"
caliburn:Message.Attach="Filter(Category)">
<TextBlock x:Name="Category" Margin="0,0,0,10" Text="{Binding Category}"/>
</Button>
</DataTemplate>
</ComboBox.ItemTemplate>
<Style x:Key="PreviousAppBarButtonStyle" TargetType="ButtonBase" BasedOn="{StaticResource AppBarButtonStyle}">
<Setter Property="AutomationProperties.AutomationId" Value="PreviousAppBarButton"/>
<Setter Property="AutomationProperties.Name" Value="Previous"/>
<Setter Property="Content" Value="&#xE112;"/>
</Style>