<?xml version="1.0" encoding="utf-8" ?>

<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">

<CodeSnippet Format="1.0.0">

<Header>

<Title>TechRepublic Sample Code Snippet</Title>

<Shortcut>trVB2</Shortcut>

<Description>Code snippet sample</Description>

<Author>Tony Patton</Author>

</Header>

<Snippet>

<Declarations>

<Literal>

<ID>connString</ID>

<ToolTip>Insert your connection string.</ToolTip>

<Default>"connection string"</Default>

</Literal>

<Literal>

<ID>sqlString</ID>

<ToolTip>Insert your T-SQL string.</ToolTip>

<Default>"Select Statement"</Default>

</Literal>

</Declarations>

<Code Language="VB">

<![CDATA[

Dim conn As System.Data.SqlClient.SqlConnection

Dim comm As System.Data.SqlClient.SqlCommand

conn = New SqlConnection($connString$)

comm = New SqlCommand($sqlString$, $connString$)

]]>

</Code>

</Snippet>

</CodeSnippet>

</CodeSnippets>