菜鸟学习C#数据库实例练习使用SqlDataReader,SqlCommand SqlConnection

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {
           string strCon="server=(local);database=northwind;uid=sa;pwd=123456";
            string select="SELECT ContactName,CompanyName FROM Customers";
            SqlConnection conn=new SqlConnection(strCon);
            conn.Open();
            SqlCommand cmd = new SqlCommand(select, conn);
            SqlDataReader aReader = cmd.ExecuteReader();
            while (aReader.Read())
                Console.WriteLine("'{0}' from {1}", aReader.GetString(0), aReader.GetString(1));
            aReader.Close();
            conn.Close();
           

           
           
            Console.ReadLine();

        }
      
      
    }
  
}