Win编程 订阅所有【Win编程】的日志

3个常用的VS2008数据库连接代码段

编辑:dnawo 日期:2012-01-31

字体大小: 小 中 大
conn.snippet：
复制内容到剪贴板程序代码 程序代码
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>创建SqlConnection</Title>
      <Shortcut>conn</Shortcut>
      <Description>-</Description>
      <Author>dnawo</Author>
      <SnippetTypes>
        <SnippetType>Expansion</SnippetType>
        <SnippetType>SurroundsWith</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Declarations>
        <Literal>
          <ID>dbname</ID>
          <ToolTip>数据库名称</ToolTip>
          <Default>hello</Default>
        </Literal>
        <Literal>
          <ID>userid</ID>
          <ToolTip>用户名</ToolTip>
          <Default>sa</Default>
        </Literal>
        <Literal>
          <ID>password</ID>
          <ToolTip>密码</ToolTip>
          <Default>sa</Default>
        </Literal>
      </Declarations>
      <Code Language="csharp">
        <![CDATA[
        using (SqlConnection conn = new SqlConnection("server=(local);database=$dbname$;user id=$userid$;password=$password$;min pool size=20;max pool size=100;Connection Lifetime=30;Enlist=true;"))
        {
            $end$
        }
        ]]>
      </Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>

cmd.snippet：
复制内容到剪贴板程序代码 程序代码
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>创建SqlCommand</Title>
      <Shortcut>cmd</Shortcut>
      <Description>-</Description>
      <Author>dnawo</Author>
      <SnippetTypes>
        <SnippetType>Expansion</SnippetType>
        <SnippetType>SurroundsWith</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Declarations>
        <Literal>
          <ID>sql</ID>
          <ToolTip>查询语句</ToolTip>
          <Default>select</Default>
        </Literal>
      </Declarations>
      <Code Language="csharp">
        <![CDATA[
        conn.Open();

        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.Connection = conn;
            cmd.CommandText = "$sql$";
            
            $end$
        }

        conn.Close();
        ]]>
      </Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>

adapter.snippet：
复制内容到剪贴板程序代码 程序代码
<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
  <CodeSnippet Format="1.0.0">
    <Header>
      <Title>创建SqlDataAdapter</Title>
      <Shortcut>adapter</Shortcut>
      <Description>-</Description>
      <Author>dnawo</Author>
      <SnippetTypes>
        <SnippetType>Expansion</SnippetType>
        <SnippetType>SurroundsWith</SnippetType>
      </SnippetTypes>
    </Header>
    <Snippet>
      <Declarations>
        <Literal>
          <ID>sql</ID>
          <ToolTip>查询语句</ToolTip>
          <Default>select</Default>
        </Literal>
      </Declarations>
      <Code Language="csharp">
        <![CDATA[
        using (SqlDataAdapter adapter = new SqlDataAdapter("$sql$", conn))
        {
            DataTable table = new DataTable();
            DataRow row;
            adapter.Fill(table);

            for (int i = 1; i < table.Rows.Count; i++)
            {
                row = table.Rows[i];
                $end$
            }
        }
        ]]>
      </Code>
    </Snippet>
  </CodeSnippet>
</CodeSnippets>


上一篇: 借助文本文件在SQL Server间导出/导入数据示例
下一篇: 新浪微博开放平台请求用户授权Token失败解决方法
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags:
最新日志:
评论: 0 | 引用: 0 | 查看次数: 3865
发表评论
请登录后再发表评论！