C#连接SQL Server数据库

项目中要使用到SQL Server数据库，下面简单介绍下C#如何连接SQL Server数据库：

using System;  
using System.Data.SqlClient;  
  
class DBConnector 
{  
    static void connectSQLServer()  
    {  
        string connectionString = "Server={服务器IP地址};Database={数据库名称};User Id={用户名};Password=your_password;";  
          
        using (SqlConnection connection = new SqlConnection(connectionString))  
        {  
            try  
            {  
                connection.Open();  
                Console.WriteLine("连接成功！");  
                  
                // 执行SQL语句
                string sqlQuery = "SELECT * FROM table";  
                using (SqlCommand command = new SqlCommand(sqlQuery, connection))  
                using (SqlDataReader reader = command.ExecuteReader())  
                {  
                    while (reader.Read())  
                    {  
                        // TODO: 处理查询结果  
                        Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));  
                    }  
                }  
            }  
            catch (SqlException e)  
            {  
                Console.WriteLine("连接失败：" + e.Message);  
            }  
        }  
          
        Console.ReadLine();  
    }  
}