Csqldataprovider And Cgridview

[easyfrag]

Hi

I’m trying to pass a CSqlDataProvider from a Controller to a View via RenderPartial.

When I run the code I get a error messag. "Error occured.please try again".

Here is my code

Controller

    $count=Yii::app()->db->createCommand('SELECT COUNT(*) FROM Rank')->queryScalar();      


    $sql = 'SELECT * FROM Rank';      


    $dataProvider=new CSqlDataProvider($sql, array(


        'totalItemCount'=>$count,                    


        'pagination'=>array('pageSize'=>10)


        ));       


    $this->renderPartial('//library/_test',array('dataProvider'=>$dataProvider),false, true);

View _test.php

$this->widget(‘zii.widgets.grid.CGridView’, array(

‘dataProvider’=>$dataProvider,

‘enablePagination’=>true,

));

[softark]

Hi easyfrag,

View _test.php

$this->widget('zii.widgets.grid.CGridView', array(

  'dataProvider'=>$dataProvider, 

  'enablePagination'=>true,

));

‘columns’?

[easyfrag]

Hi easyfrag,

‘columns’?

thanks for the replay, it was missing a keyfield… its working now