当前位置:Gxlcms > 数据库问题 > C# 连接 SQL Server 简单教程

C# 连接 SQL Server 简单教程

时间:2021-07-01 10:21:17 帮助过:8人阅读

控制台应用程序

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

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

  1. <span style="color: #0000ff;">using</span><span style="color: #000000;"> System;
  2. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Collections.Generic;
  3. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Linq;
  4. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Text;
  5. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Threading.Tasks;
  6. </span><span style="color: #0000ff;">using</span><span style="color: #000000;"> System.Data.SqlClient;
  7. </span><span style="color: #0000ff;">namespace</span><span style="color: #000000;"> LinkSqlConsole
  8. {
  9. </span><span style="color: #0000ff;">class</span><span style="color: #000000;"> Program
  10. {
  11. </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)
  12. {
  13. SqlConnection conn </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlConnection();
  14. 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>
  15. <span style="color: #000000;"> conn.Open();
  16. SqlCommand cmd </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> SqlCommand();
  17. cmd.Connection </span>=<span style="color: #000000;"> conn;
  18. 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>
  19. <span style="color: #000000;"> cmd.ExecuteNonQuery();
  20. SqlDataReader sqlDataReader </span>=<span style="color: #000000;"> cmd.ExecuteReader();
  21. </span><span style="color: #0000ff;">while</span><span style="color: #000000;"> (sqlDataReader.Read())
  22. {
  23. </span><span style="color: #0000ff;">string</span> stuID = sqlDataReader.GetString(<span style="color: #800080;">0</span><span style="color: #000000;">);
  24. </span><span style="color: #0000ff;">string</span> stuName = sqlDataReader.GetString(<span style="color: #800080;">1</span><span style="color: #000000;">);
  25. </span><span style="color: #0000ff;">int</span> age = sqlDataReader.GetInt32(<span style="color: #800080;">2</span><span style="color: #000000;">);
  26. 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);
  27. }
  28. sqlDataReader.Close();
  29. conn.Close();
  30. }
  31. }
  32. }</span>

 

 

Pic1

 技术分享

 

Pic2

技术分享

 

 Pic3

技术分享

 

C# 连接 SQL Server 简单教程

标签:

人气教程排行