String strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/1.mdb";
这样写:
OleDbConnection conn;
conn = new OleDbConnection(strCon);
conn.Open();OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM Topic WHERE BoardID=1 AND ParendID<0" , conn ) ;DataSet ds = new DataSet();
myCommand.Fill(ds,"Topic");
DataTable dt = ds.Tables["Topic"];
DataView dv = new DataView(dt,"BoardID=1 AND ParentID < 0 ","LastReplyTime DESC",DataViewRowState.OriginalRows );
这样写:
OleDbConnection conn;
conn = new OleDbConnection(strCon);
conn.Open();OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM Topic WHERE BoardID=1 AND ParendID<0" , conn ) ;DataSet ds = new DataSet();
myCommand.Fill(ds,"Topic");
DataTable dt = ds.Tables["Topic"];
DataView dv = new DataView(dt,"BoardID=1 AND ParentID < 0 ","LastReplyTime DESC",DataViewRowState.OriginalRows );
OleDbConnection conn = new OleDbConnection(strCon);
sql = "select * from Topic where ParentID < 0 and BoardID = 1"
OleDbDataAdapter myCommand = new OleDbDataAdapter(sql, conn ) ;DataSet ds = new DataSet();
myCommand.Fill(ds,"Topic");
TopicCount=ds.Tables[0].Rows.Count;