使用SQL语句来填充CGridView [ 新手入门 ]

$count=Yii::app()->db->createCommand('SELECT COUNT(*) FROM tbl_user')->queryScalar();
$sql='SELECT * FROM tbl_user';
$dataProvider=new CSqlDataProvider($sql, array(
  'id'=>'user',
  'totalItemCount'=>$count,
  'sort'=>array(
    'attributes'=>array(
      'id', 'username', 'email',
    ),
  ),
  'pagination'=>array(
    'pageSize'=>10,
  ),
));
//$dataProvider->getData() will return a list of arrays.

在view视图中使用和CActiveDataProvider使用的方法一样