C# 连接 SQL Server 简单教程

2.转到服务器资源管理器，在数据连接处右击添加连接(Pic1)，输入服务器名和数据库名称（有时候服务器名有下拉框中不会出现，可以到SQL Server Management Studio中复制进去,Pic2黑色条状处就是）,点出测试连接，如果失败，需要查看服务是否启动

3.在程序中写入以下代码即可运行

<span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
</span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
</span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
</span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
</span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Threading.Tasks;
</span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
</span><span style="color: #0000ff;">namespace</span><span style="color: #000000;"> LinkSqlConsole
{
    </span><span style="color: #0000ff;">class</span><span style="color: #000000;"> Program
    {
        </span><span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span> Main(<span style="color: #0000ff;">string</span><span style="color: #000000;">[] args)
        {
                SqlConnection conn </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection();
                conn.ConnectionString </span>= <span style="color: #800000;">"</span><span style="color: #800000;">连接字符串</span><span style="color: #800000;">"</span>;<span style="color: #008000;">//</span><span style="color: #008000;">见图Pic3</span>
<span style="color: #000000;">                conn.Open();
                SqlCommand cmd </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlCommand();
                cmd.Connection </span>=<span style="color: #000000;"> conn;
                cmd.CommandText </span>= <span style="color: #800000;">"</span><span style="color: #800000;">SQL语句</span><span style="color: #800000;">"</span>;<span style="color: #008000;">//</span><span style="color: #008000;">SELECT * FROM 表名</span>
<span style="color: #000000;">                cmd.ExecuteNonQuery();
                SqlDataReader sqlDataReader </span>=<span style="color: #000000;"> cmd.ExecuteReader();
                </span><span style="color: #0000ff;">while</span><span style="color: #000000;"> (sqlDataReader.Read())
                {
                    </span><span style="color: #0000ff;">string</span> stuID = sqlDataReader.GetString(<span style="color: #800080;">0</span><span style="color: #000000;">);
                    </span><span style="color: #0000ff;">string</span> stuName = sqlDataReader.GetString(<span style="color: #800080;">1</span><span style="color: #000000;">);
                    </span><span style="color: #0000ff;">int</span> age = sqlDataReader.GetInt32(<span style="color: #800080;">2</span><span style="color: #000000;">);
                    Console.WriteLine(stuID </span>+ <span style="color: #800000;">"</span> <span style="color: #800000;">"</span> + stuName + <span style="color: #800000;">"</span> <span style="color: #800000;">"</span> +<span style="color: #000000;"> age);
                }
                sqlDataReader.Close();
                conn.Close();
        }
    }
}</span>

Pic1

Pic2

 Pic3

C# 连接 SQL Server 简单教程

标签：