C# 连接 SQL Server 简单教程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace LinkSqlConsole
{
    class Program
    {
        static void Main(string[] args)
        {
                SqlConnection conn = new SqlConnection();
                conn.ConnectionString = "连接字符串";//见图Pic3
                conn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "SQL语句";//SELECT * FROM 表名
                cmd.ExecuteNonQuery();

                SqlDataReader sqlDataReader = cmd.ExecuteReader();

                while (sqlDataReader.Read())
                {
                    string stuID = sqlDataReader.GetString(0);
                    string stuName = sqlDataReader.GetString(1);
                    int age = sqlDataReader.GetInt32(2);
                    Console.WriteLine(stuID + " " + stuName + " " + age);
                }
                sqlDataReader.Close();
                conn.Close();
        }
    }
}