时间:2021-07-01 10:21:17 帮助过:8人阅读
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 简单教程
标签: