CArrayDataProvider gridview

$rawData=Yii::app()->db->createCommand($sql)->queryAll();或者其他数组形式

$dataProvider=new CArrayDataProvider($rawData, array(
    'keyField'=>'id',
    
    'sort'=>array(
        'attributes'=>array(
             'id', 'category',
        ),
    ),
    'pagination'=>array(
        'pageSize'=>10,
    ),
));


$this->widget('zii.widgets.grid.CGridView', array(
    'id'=>'category-grid',
    'dataProvider'=>$dataProvider,
    //'filter'=>$model,
    'columns'=>array(
        'id',
        'category',
        array(
            'class'=>'CButtonColumn',
                        'viewButtonUrl'=>'Yii::app()->controller->createUrl("view",array("id"=>$data["id"]))',
                        'updateButtonUrl'=>'Yii::app()->controller->createUrl("update",array("id"=>$data["id"]))',
                        'deleteButtonUrl'=>'Yii::app()->controller->createUrl("delete",array("id"=>$data["id"]))',
        ),
    ),
));