- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data;
- using System.Data.OleDb;
- namespace ConsoleApplication1
- {
- class Program
- {
- static void Main(string[] args)
- {
- OleDbConnection conn = new OleDbConnection();
- OleDbCommand comm = new OleDbCommand();
- OleDbDataReader dr=null;
- conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Environment.CurrentDirectory + "\\\\SimpleNews.mdb";
- comm.Connection = conn;
- comm.CommandText = "select * from [login]";
- try
- {
- conn.Open();
- dr = comm.ExecuteReader();
- while (dr.Read())
- {
- for (int i = 0; i < dr.FieldCount; i++)
- Console.Write(dr.GetValue(i) + " ");
- Console.WriteLine("");
- //dr.Close();
- }
- dr.Close();
- }
- catch (Exception err)
- {
- Console.WriteLine(err.Message);
- }
- finally
- {
- comm = null;
- conn.Close();
- comm = null;
- Console.ReadKey();
- }
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/2209201513730.html
来源: http://www.codesnippet.cn/detail/2209201513730.html