数据库链接

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;  //引用命名空间

namespace ConsoleApplication8
{
    class Program
    {
        static void Main(string[] args)
        {
            string yu = @"Data Source=PC-20120701OAHI\SQLEXPRESS;Initial Catalog=mydb1;User ID=sa;password=shuyu+ast;";  //链接数据库语句
            SqlConnection wei=new SqlConnection(yu);
            wei.Open();
            Console.WriteLine("打开");
            Console.ReadKey();

            string num1 = "select top(1) * from t_person1";
            SqlCommand Person = new SqlCommand(num1, wei);
            SqlDataReader count = Person.ExecuteReader();
            while (count.Read())  //判断返回的内容是否有值
            {
                Console.WriteLine(string.Format("编号:{0},姓名:{1},年龄:{2},日期:{3}", count[0], count[1], count[2], count[3]));
            }
            Console.ReadKey();
        }
    }
}