need to pass the values from VF page to soql statement and fetch records

Question

Page:

<apex:page controller="statement" >
<apex:form >
<apex:outputLabel value="From Date"/>
<apex:inputText value="{!fromDate}"/><br/>
<apex:outputLabel value="TO Date"/>
<apex:inputText value="{!toDate}"/><br/> <br/>
<apex:commandButton value="Download" action="{!show}"/>
</apex:form>
</apex:page>

Code:

public class statement {
    list<Account> acc; 
    public PageReference show() {
        acc = new list<Account>();
        acc= [select id,name,industry from Account where date =:fromdate]
        return acc;
    }
    public String toDate { get; set; }
    public String fromDate { get; set; }
}

im struck here while its asking return

Answer 1

Try the modification

Page

<apex:page controller="statement" >
  <apex:form >
    <apex:outputLabel value="From Date"/>
    <apex:inputText value="{!fromDate}"/><br/>
    <apex:outputLabel value="TO Date"/>
    <apex:inputText value="{!toDate}"/><br/> <br/>
    <apex:commandButton value="Download" action="{!show}"/>
  </apex:form>
  Output: {!acc}
</apex:page>

Class

public class statement {
    public list<Account> acc {get; private set;}
    public void show() {
        Date df = Date.ValueOf(fromdate);
        Date dt = Date.ValueOf(toDate);
        acc= [ select id,name,industry from Account where createddate >= :df AND createddate < :dt ];
    }
    public String toDate { get; set; }
    public String fromDate { get; set; }
    public statement(){
        acc = new list<Account>();
    }
}

The screen output

Answer 2

There are many issue, one bing that I do not see a way for you to display the return value. Are you trying to display the results?

Lets start by the 1st main issue that you have the method defined as returning a page reference but you are returning a list of accounts: it should be

public List<Account> show() {
        acc = new list<Account>();
        acc= [select id,name,industry from Account where date =:fromdate]
        return acc;
    }