Access 数据库如何返回DataTable

Question

 OleDbConnection conn = new OleDbConnection(strconn);
        try
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = sql;
            cmd.Connection = conn;
            this.str = Convert.ToString(cmd.ExecuteScalar());
        }
        catch (Exception er)
        {
            Response.Write(er.ToString());
        }

Answer 1

DataSet dataset = new DataSet();
DataAdapter adapter = new DataAdapter(sql,conn)
DataAdapter.Fill(dataset，"mytalbe");
Datatable table = dataset.tables["mytalbe"];

Answer 2

string connstr="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=F:\\A.mdb";
OleDbConnection conn= new OleDbConnection(connstr);OleDbDataAdapter adapter = new OleDbDataAdapter();
string sqlstr="select * from A order by ID desc";
mydataset= new System.Data.DataSet();
adapter.SelectCommand = new OleDbCommand(sqlstr, conn);
adapter.Fill(mydataset,"AA"); 
conn.Close();

Answer 3

public DataTable getdt(string strsql,string tablename)
{
OleDbDataAdapter adapter = new OleDbDataAdapter(strsql,conn); 
DataSet ds = new DataSet();
adapter.Fill(ds,tablename); 
DataTable dt = new DataTable();
dt=ds.Table[0].DefultView;
return dt;
}

Answer 4

完整些public DataTable getdt(string strsql,string tablename)
{OleDbConnection conn = new OleDbConnection(strconn); 
conn.Open(); 
OleDbDataAdapter adapter = new OleDbDataAdapter(strsql,conn); 
DataSet ds = new DataSet();
adapter.Fill(ds,tablename); 
DataTable dt = new DataTable();
dt=ds.Table[0].DefultView;
conn.Close(); 
return dt;
}