最简单的C#操作数据库程序

//  最简单的C#操作数据库程序


using System;
using System.Data.OleDb;
class OleDbTest
{
    public static void Main()
    {
        //创建数据库连接
        OleDbConnection aConnection = new OleDbConnection(
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=wms.mdb");
        //创建command对象并保存sql查询语句
        OleDbCommand aCommand = new OleDbCommand("select * from IN_PAGE",
            aConnection);
        try
        {
            aConnection.Open();
            //创建datareader 对象来连接到表单
            OleDbDataReader aReader = aCommand.ExecuteReader();
            Console.WriteLine("This is the returned data from IN_PAGE table");
            //Console.WriteLine(aReader.GetInt32(0).ToString());
            //循环遍历数据库
            while (aReader.Read())
            {
                // And iterate through the data
                Console.WriteLine("{0,-30} {1,30},{2,30}", aReader[0],
                    aReader[1], aReader[2]);
                // Console.WriteLine(aReader.GetInt32(0).ToString());
            }
            //关闭reader对象
            aReader.Close();
            //关闭连接,这很重要
            aConnection.Close();
        }
        //一些通常的异常处理
        catch (OleDbException e)
        {
            Console.WriteLine("Error: {0}", e.Errors[0].Message);
        }
    }
}