how to get product details in admin grid?

Question

here is my prepareCollection from this how to get product name and price and status

protected function _prepareCollection()
{
    $store = $this->_getStore(); 
    $collection = Mage::getModel('catalog/product_link')    
                       ->getCollection() 
                       ->addFieldToFilter('product_id',$this->_getProductId())
                       ->addFieldToFilter('link_type_id','1');
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

Answer 1

Go to your product link collection class and add a method

public function addProductData($attributesCodes)
{
    foreach ($attributesCodes as $attributeCode) {
        $attributeTableAlias = $attributeCode . '_table';
        $attribute = Mage::getSingleton('eav/config')
            ->getAttribute(Mage_Catalog_Model_Product::ENTITY, $attributeCode);

        $this->getSelect()->join(
           array($attributeTableAlias => $attribute->getBackendTable()),
             "main_table.product_id = {$attributeTableAlias}.entity_id AND {$attributeTableAlias}.attribute_id={$attribute->getId()}",
        array($attributeCode => 'value')
    );
        $this->_map['fields'][$attributeCode] = 'value';
    }
    return $this;
}

Then in your block's _prepareCollection() you can call this method

protected function _prepareCollection()
{
    $store = $this->_getStore(); 
    $collection = Mage::getModel('catalog/product_link')    
                   ->getCollection() 
                   ->addFieldToFilter('product_id',$this->_getProductId())
                   ->addFieldToFilter('link_type_id','1');
    $collection->addProductData(array('name', 'price', 'status'));
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

Now you can add 'name', 'price', 'status' columns in _prepareColumns().