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();
}
}
}