How to display names of Contact & Opportunity related to an Account in a Visualforce Page?

Hi,

The below code will help you

Apex Class

public class AccountRelatedContactsOpportunities {

public List<Contact> getContacts() {
List<Contact> conresults = [Select Id, FirstName, LastName,Title,Email from Contact where accountid='0012800000hVdfO'];
return conresults;
}
public List<Opportunity> getOpportunities() {
List<Opportunity> oppresults = [Select Id,CloseDate,Amount,StageName,Name from Opportunity where accountid='0012800000hVdfO'];
return oppresults;
}

}

VisualForce Page

<apex:page controller="AccountRelatedContactsOpportunities">
<apex:form>
<apex:pageBlock title="Contacts List" id="contacts_list">
<apex:pageBlockTable value="{! contacts }" var="ct">
<apex:column value="{! ct.FirstName }"/>
<apex:column value="{! ct.LastName }"/>
<apex:column value="{! ct.Title }"/>
<apex:column value="{! ct.Email }"/>
</apex:pageBlockTable>
</apex:pageBlock>
<apex:pageBlock title="Opportunity List" id="opportunity_list">
<apex:pageBlockTable value="{! opportunities }" var="ot">
<apex:column value="{! ot.Name }"/>
<apex:column value="{! ot.CloseDate }"/>
<apex:column value="{! ot.StageName }"/>
<apex:column value="{! ot.Amount }"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>

Here I am using hard coded Account Id. You can replace it with yours or you can fetch it dynamically also.

The below is the preview of VF page

<apex:page controller="AccountContactOpportunity">
<apex:form >
<apex:pageBlock title="Account Name">
<apex:selectList value="{!AccId}" size="1">
<apex:selectOptions value="{!AccountNames}"/>
<apex:actionSupport event="onchange" action="{!showContact}" reRender="co,co1"/>
</apex:selectList>
<apex:pageBlock title="Opportunity list" id="co" >
<apex:pageBlockTable value="{!opplist}" var="opp">
<apex:column value="{!opp.Name}"/>
<apex:column value="{!opp.StageName}"/>
</apex:pageBlockTable>
</apex:pageBlock>
<apex:pageBlock title="Contact list" id="co1">
<apex:pageBlockTable value="{!conlist}" var="con">
<apex:column value="{!con.Name}"/>
<apex:column value="{!con.Email}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:pageBlock>
</apex:form>
</apex:page>

public class AccountContactOpportunity
{
public String AccId{get;set;}
public list<contact> conlist{get;set;}
public list<Opportunity> opplist{get;set;}

public List<SelectOption> getAccountNames()
{
List<SelectOption> accOptions= new List<SelectOption>();
accOptions.add( new SelectOption('','--Select--'));
for( Account acc : [select Id,name from Account where name like 'a%'] )
{
accOptions.add( new SelectOption(acc.Id,acc.name));
}
return accOptions;
}
public pageReference showContact()
{
conlist=[select Name,Email from contact where accountid =:AccId];
system.debug('----->'+conlist);
opplist=[select Name,stageName from opportunity where accountid=:AccId];
system.debug('====>'+opplist);
return null;
}
}

Adding some points:

<apex:page standardController="Account">
Name : <apex:outputField value="{!Account.Name}"/> <br/>
Phone : <apex:OutputField value="{!Account.Phone}" /><br/>
<br/>
<b>Contact List</b><br/>
<apex:dataTable value="{!Account.Contacts}" var="con">
<apex:column value="{!con.Name}"/>
</apex:dataTable><br/><br/>
<b>Opportunity List</b><br/>
<apex:dataTable value="{!Account.Opportunities}" var="opty">
<apex:column value="{!opty.Name}"/>
</apex:dataTable>
</apex:page>

Thanks