SELECT pingfen,COUNT(*) AS s FROM pinglun GROUP BY pingfen order by s desc 结果如下: ----------- pingfen s 1 5 15 2 4 3 3 3 2 4 2 1 请问这个结果怎么获取呢,就在asp.net 程序中如何得到呢,就是我能不能让 a=15,b=3,c=2,d=1 这样子,在线等候,谢谢了
sqlconn = new SqlConnection(configstring);
SqlDataAdapter sqldrp = new SqlDataAdapter(‘SELECT pingfen,COUNT(*) AS s FROM pinglun GROUP BY pingfen order by s desc’, sqlconn);
DataSet ds = new DataSet();
sqldrp.Fill(ds);