string sql = @"SELECT * FROM WebSite_CMS_Content ORDER BY pkID DESC";
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["WebSiteClusterConnectionStringOleDb"].ConnectionString);
OleDbDataAdapter da = new OleDbDataAdapter(sql, connection);
DataSet ds = new DataSet("RadGridContent");
da.Fill(ds, "RadGridTemp");
Response.Write(ds.Tables[0].Rows.Count);
上面查询是正确的,但是sql语句一加where,查询结果就为零,郁闷死了。
@"SELECT * FROM WebSite_CMS_Content WHERE CateID=1 ORDER BY pkID DESC";
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["WebSiteClusterConnectionStringOleDb"].ConnectionString);
OleDbDataAdapter da = new OleDbDataAdapter(sql, connection);
DataSet ds = new DataSet("RadGridContent");
da.Fill(ds, "RadGridTemp");
Response.Write(ds.Tables[0].Rows.Count);
上面查询是正确的,但是sql语句一加where,查询结果就为零,郁闷死了。
@"SELECT * FROM WebSite_CMS_Content WHERE CateID=1 ORDER BY pkID DESC";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货