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"]))',
        ),
    ),
));　　

转载于:https://www.cnblogs.com/xiaoluozi513/archive/2011/07/24/2115329.html