<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>建立參數化 SELECT 命令</Title>
      <Author>Microsoft Corporation</Author>
      <Description>建構用來執行含有參數之 Select 陳述式的命令物件。</Description>
      <Shortcut>adoSelectwParams</Shortcut>
    </Header>
    <Snippet>
      <References>
        <Reference>
          <Assembly>System.Data.dll</Assembly>
        </Reference>
        <Reference>
          <Assembly>System.Xml.dll</Assembly>
        </Reference>
      </References>
      <Imports>
        <Import>
          <Namespace>System.Data.SqlClient</Namespace>
        </Import>
        <Import>
          <Namespace>System.Data</Namespace>
        </Import>
      </Imports>
      <Declarations>
        <Literal>
          <ID>SQL</ID>
          <Type>String</Type>
          <ToolTip>取代為 SQL 陳述式。</ToolTip>
          <Default>SELECT CustomerID, CompanyName FROM Customers WHERE CompanyName LIKE @companyName</Default>
        </Literal>
        <Object>
          <ID>parameter1</ID>
          <Type>SqlParameter</Type>
          <ToolTip>取代為程式碼中參考的參數名稱。</ToolTip>
          <Default>companyNameParam</Default>
        </Object>
        <Literal>
          <ID>sqlParameterName</ID>
          <Type>String</Type>
          <ToolTip>在您的查詢忠將此項取代為 SQL 參數。</ToolTip>
          <Default>@companyName</Default>
        </Literal>
        <Literal>
          <ID>parameterValue</ID>
          <Type>String</Type>
          <ToolTip>取代為參數值。</ToolTip>
          <Default>"a%"</Default>
        </Literal>
        <Object>
          <ID>conn</ID>
          <Type>SqlConnection</Type>
          <ToolTip>取代為連接物件。</ToolTip>
          <Default>conn</Default>
        </Object>
        <Object>
          <ID>cmd</ID>
          <Type>SqlCommand</Type>
          <ToolTip>取代為您的 SqlCommand 的物件名稱。</ToolTip>
          <Default>cmd</Default>
        </Object>
      </Declarations>
      <Code Language="VB" Kind="method body"><![CDATA[Dim $cmd$ As New SqlCommand
$cmd$.CommandType = CommandType.Text
$cmd$.CommandText = "$SQL$"
$cmd$.Connection = $conn$
' Create a SqlParameter for each parameter in the stored procedure.
Dim $parameter1$ As New SqlParameter("$sqlParameterName$", $parameterValue$)
$cmd$.Parameters.Add($parameter1$)
]]></Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>
