SQL Server：本机客户端与 ODBC

SQL Server：本机客户端与 ODBC

csharp
using System;
using System.Data.SqlClient;
class Program
{
    static void Main()
    {
        string connectionString = "Data Source=服务器名称;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            string sql = "SELECT * FROM 表名";
            SqlCommand command = new SqlCommand(sql, connection);
            
            SqlDataReader reader = command.ExecuteReader();
            
            while (reader.Read())
            {
                Console.WriteLine(reader["列名"]);
            }
            
            reader.Close();
        }
    }
}

csharp
using System;
using System.Data.Odbc;
class Program
{
    static void Main()
    {
        string connectionString = "Driver={SQL Server};Server=服务器名称;Database=数据库名称;Uid=用户名;Pwd=密码;";
        
        using (OdbcConnection connection = new OdbcConnection(connectionString))
        {
            connection.Open();
            
            string sql = "SELECT * FROM 表名";
            OdbcCommand command = new OdbcCommand(sql, connection);
            
            OdbcDataReader reader = command.ExecuteReader();
            
            while (reader.Read())
            {
                Console.WriteLine(reader["列名"]);
            }
            
            reader.Close();
        }
    }
}