给你个简单的例子吧 using (OleDbConnection connection = new OleDbConnection(connectionString))//先建立Connection对象
{
OleDbCommand cmd = new OleDbCommand(SQLString);//建立Command对象,用Select命令
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))//利用Command对象,建立DataAdapter对象
{
DataSet ds = new DataSet();//建立DataSet对象da.Fill(ds, "Tablename");//填充
}}