February 6, 2013

How to fetch data from Controller and display it in Visualforce page without using button?

To fetch data from Controller and display it in Visualforce page without using button, retrieve the record in the constructor.

Sample code:

Visualforce page:

<apex:page controller="Sample" >
    <apex:form >
       <apex:pageblock id="account" title="Account Details(Standard Object)" >
            <apex:pageblockTable value="{!acc}" var="a">
                <apex:column value="{!a.Name}"/>
                <apex:column value="{!a.AccountNumber}"/>
            </apex:pageblockTable>
        </apex:pageblock>
       <apex:pageblock id="member" title="Member Details(Custom Object)">
            <apex:pageblockTable value="{!mem}" var="m">
                <apex:column value="{!m.Name}"/>
            </apex:pageblockTable>         
        </apex:pageblock>          
    </apex:form>
</apex:page>


Controller:

public with Sharing class Sample
{   
    public List<Account> acc {get;set;}
    public List<Member__c> mem {get;set;}   
      
    public sample()
    {
        acc = [SELECT Name, AccountNumber FROM Account];
        mem = [SELECT Name FROM Member__c];
    }
}


Output:

6 comments:

  1. hi
    i have one request
    search the picklist value get the data on table formade using bootstrup method

    ReplyDelete
    Replies
    1. Yes. Once you get the result from the apex convert it to JSON and use bootstrap methods to show it. Let me know if that works.

      Delete
  2. I want to know about the how to fetch data in custom object can you please share some suggestions about it. Thanks

    ReplyDelete
    Replies
    1. In the example used, Member__c is a custom object.

      Delete
  3. Can i know to display the data in another Vf page by clicking on button

    ReplyDelete
    Replies
    1. Try this - https://blogs.perficient.com/2015/03/16/how-to-embed-visualforce-pages-in-visualforce-pages-issues-and-solution/

      Delete