Exemplo n.º 1
0
        /// <summary>
        /// 获取前N条记录(未实现MySql功能)
        /// add by tintown at 2004-09-06
        /// </summary>
        /// <param name="cmd"></param>
        /// <param name="top"></param>
        /// <returns></returns>
        public override DataTable AsDataTable(IDbCommand cmd, int top)
        {
            cmd.Connection  = this.connection;
            cmd.Transaction = this.transaction;
            string cmdText = cmd.CommandText;


            //使用ORCALE添加rownum的方法重装SQL语句
            cmd.CommandText = PersistenceBroker.AddMySqlTopWhere(cmdText, top);
            MySqlDataAdapter adapter = new MySqlDataAdapter((MySqlCommand)cmd);
            DataTable        dt      = new DataTable();

            adapter.Fill(dt);
            return(dt);
        }