DataSet ds1 = new DataSet();
string sql="select * from test where class = 2 order by id desc";
OleDbCommand cmd=new OleDbCommand(sql,conn);
DataSet ds=new DataSet();
OleDbDataAdapter adapter1=new OleDbDataAdapter(cmd);
adapter1.Fill(ds1);
string sql="select * from test where class = 2 order by id desc";
OleDbCommand cmd=new OleDbCommand(sql,conn);
DataSet ds=new DataSet();
OleDbDataAdapter adapter1=new OleDbDataAdapter(cmd);
adapter1.Fill(ds1);
select * from test where class = 1 or class = 2 order by id descor2.
const String strconn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=Z:\\test.mdb";
OleDbConnection conn=new OleDbConnection(strconn);
DataSet ds=new DataSet();
conn.Open();
string sql="select * from test where class = 1 order by id desc";
OleDbCommand cmd=new OleDbCommand(sql,conn);
OleDbDataAdapter adapter1=new OleDbDataAdapter(cmd);
adapter1.Fill(ds,"class1");sql="select * from test where class = 2 order by id desc";
adapter1.SelectCommand.CommandText = sql;
adapter1.Fill(ds,"class2");conn.Close();
所以不可以用saucer(思归, MS .NET MVP)的第一種方法啦!
関於第二種方法,我怎麽調用呢?
ds.class1
ds.class2
??
比如我要調用class1字段中的id字段等於1的記錄,應該怎麽coding呢?謝謝各位了!
DataRow[] drs = dt.Select("id = '1'");