<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>Create SQLDataAdapter when given the Database Name and the required SQL string</Title>
      <Shortcut>CreateSQLDataAdapterwhengiventheDatabaseNameandtherequiredSQLstring</Shortcut>
      <Description>Create SQLDataAdapter when given the Database Name and the required SQL string [C#]</Description>
      <Author>Ryan  Blake</Author>
      <HelpUrl>/PreviewSnippet.aspx?SnippetID=91d7fd28-beb1-46f5-92a9-72695f4b5ab8</HelpUrl>
      <SnippetTypes>
        <SnippetType>SurroundsWith</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Code Language="csharp"><![CDATA[public static SqlDataAdapter MakeSqlAdapter(string SqlString, string DataBase)
        {
            SqlConnection sqlConn = new             SqlConnection("server=127.0.0.1;uid=sa;pwd=;database="+DataBase);
            SqlDataAdapter daConn = new SqlDataAdapter(SqlString, sqlConn);
            sqlConn.Close();
            return daConn;
        }]]></Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>