数据库的连接 [1]

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

namespace ConsoleApplication1
{
    class Program
    {
        public const string ConnectionString = "provider=Microsoft.Jet.OleDb.4.0;Data Source=**.mdb";
        /// <summary>
        /// 用数据适配器来创建连接
        /// </summary>
        /// <param name="args"></param>
        static void Main(string[] args)
        {
            OleDbDataAdapter da= new OleDbDataAdapter(/*sql语句*/,ConnectionString);
            DataTable dt=new DataTable();
            da.Fill(dt);

            Console.WriteLine("{0}\t\t{1}",dt.Columns[0].ColumnName);

            foreach(DataRow dr in dt.Rows)
            {
                Console.WriteLine("{0}\t\t{1}",dr[0],dr[1]);
            }
        }
    }
}