コード例 #1
0
        // 畅销榜
        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();
        }