Else's blog

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

namespace test.src.util
{
    public class DbConnction
    {
        public DbConnction()
        {
            //
        }

        static void Main(string[] args)
        {

            String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
            connectionString += @"d:\data.mdb";
            OleDbConnection myConnection = new OleDbConnection(connectionString);
            
            myConnection.Open();        //打开数据库链接
            OleDbCommand myCommand = myConnection.CreateCommand();    //定义SqlCommand变量
          

            myCommand.CommandText = "select * from ruby";           //设置SQL语句
            OleDbDataReader myDataReader = myCommand.ExecuteReader(); // 从数据库获职数据
            
            //读取DataReader中的数据并输出

            while (myDataReader.Read())
            {
                Console.WriteLine("\t{0}\t{1}", myDataReader["id"], myDataReader["title"]);
            }

            myDataReader.Close();               //关闭SqlDataReader
            myConnection.Close();               //关闭链接
            
            Console.WriteLine("这个是一个链接的测试");
        }

    }
}