using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Documents and Settings\\Administrator\\My Documents\\Database1.accdb;Persist Security Info=False;"); //2007
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\Database1.mdb;"); //2003
conn.Open();
string selectstr = "select * from xx";
OleDbCommand selectcmd = new OleDbCommand(selectstr,conn);
OleDbDataAdapter selectda = new OleDbDataAdapter();
selectda.SelectCommand = selectcmd;;
DataSet ds = new DataSet();
selectda.Fill(ds, "box");
conn.Close();