custom sql query results to CDetailView

How-tos

custom, sql, query, CDetailView, CSqlDataProvider, CArrayDataProvider

----------------------------------------------------------
I show you now how to make the similar task using other Providers

**With CSqlDataProvider**

 
```php 
$sqlProvider = new CSqlDataProvider('select * from your_table');
 
$sqlProvider = $sqlProvider->getData();
 
$sqlData = $sqlProvider[0];
 
$this->widget('zii.widgets.CDetailView', array( 'data' => $sqlData, )); ```
 
**With CArrayDataProvider**
 
 
 
```php 
$connection = Yii::app()->db;
 
$command = $connection->createCommand('select * from your_table');
 
$row = $command->queryRow(); $sqlData = new CArrayDataProvider(array($row));
 
$sqlData = $sqlData->getData();
 
$sqlData = $sqlData[0];
 
$this->widget('zii.widgets.CDetailView', array( 'data' => $sqlData, ));
 
```