// 畅销榜 protected void SalesData() { DB db = new DB(); string sql = "select top 10 序号 = row_number() over(order by Sales desc), Id, Name, Price from Book"; db.LoadExecuteData(sql); SalesDataList.DataSource = db.MyDataSet.Tables[0].DefaultView; SalesDataList.DataKeyField = "Id"; SalesDataList.DataBind(); db.OffData(); }