C#中如何连接SQL数据库 并获取数据

using System;
using System.Data.SqlClient;
namespace _09_01
{
 class Class_09_01
 {
  public static void Main(String [] args)
  {
   string strConn="Initial Catalog=Northwind;Data Source=59.69.122.212;User ID=sa; Password=123456";
  
   SqlConnection conn=new SqlConnection();
   conn.ConnectionString = strConn;
   try
   {
    conn.Open();
    Console.WriteLine("成功连接到数据库！");
    Console.WriteLine("data sourc:{0}",conn.DataSource);
    Console.WriteLine("database name:{0}",conn.Database);
    Console.WriteLine("client name:{0}",conn.WorkstationId);
    SqlCommand cmd=new SqlCommand("select CategoryID,CategoryName from Categories",conn);
    
    

    SqlDataReader dr=cmd.ExecuteReader();
    while(dr.Read())
    {
     Console.WriteLine("\t{0}\t{1}",dr.GetInt32(0),dr.GetString(1));
    }
    dr.Close();
    conn.Close();

    
   }
   catch(Exception e)
   {
    Console.WriteLine("无法连接到数据库！");
    Console.WriteLine(e.Message);
   }
  }
 
 }
}