Adding Parameters to Filter by Date text filed, drop down menu and ref No text field
<p>can someone please help me to Add a Parameters to be  Filter by Date text filed, drop down menu and ref No text field from sql server to view result.</p>

<p>am trying to display a result from my sql server with repeat region, but l want it to be filter according to date, Reference number and a drop down filed called crop  year.</p>

<p>this what l ve done so far. </p>

<pre><code>&lt;body&gt;
&lt;form action="&amp;nbsp" id="form1" name="form1"&gt;
&lt;p align="right"&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;

&lt;table width="589" height="389" border="0" align="center" cellpadding="1"      cellspacing="1" class="tablet"&gt;
&lt;tbody&gt;&lt;tr&gt;
  &lt;td height="182" colspan="3"&gt;&lt;div align="center"&gt;&lt;img src="" width="110" height="156"&gt;&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td height="30" colspan="3" background=""&gt;&lt;div align="center" class="style22"&gt;SUMMARY OF DAILY PORT SITUATION TEMA&lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td height="28" colspan="3"&gt;&lt;div align="justify"&gt;Provide &lt;strong&gt; Entry Date&lt;/strong&gt; and &lt;strong&gt;Report Refence Number&lt;/strong&gt;  to have access Summary Of Daily Port Situation Report. &lt;/div&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td height="50" colspan="3" background=""&gt;&lt;hr&gt;
    &lt;span class="style22"&gt;INSTRUCTIONS:&lt;br&gt;
    &lt;/span&gt;Enter Entry date in this format &lt;strong&gt;yyyy/mm/dd&lt;/strong&gt;. &lt;br&gt;
    &lt;strong&gt;Example:&lt;/strong&gt; 12th Nov 1984 should be entered as: &lt;strong&gt;1984/11/12&lt;/strong&gt; or click on the &lt;strong&gt;select from calender&lt;/strong&gt; below &lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td width="234" height="25" background=""&gt;&lt;div align="right" class="style22"&gt;Entry Date&lt;/div&gt;&lt;/td&gt;
  &lt;td height="25" colspan="2"&gt;&lt;label&gt;
    &lt;input name="x_dob" type="text" id="x_dob" size="30"&gt; 
  &lt;/label&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
  &lt;td height="10" background=""&gt;&lt;div align="right" class="style22"&gt;Crop Year: &lt;/div&gt;&lt;/td&gt;
  &lt;td width="243" height="10"&gt;&lt;label&gt;

    &lt;select name="CropYear" id="CropYear" tabindex="2"&gt;
        &lt;option value=""&gt;&lt;/option&gt;

        &lt;option value=""&gt;&lt;/option&gt;
      &lt;/select&gt;
  &lt;/label&gt;&lt;/td&gt;
  &lt;td width="98"&gt;&amp;nbsp;&lt;/td&gt;
&lt;/tr&gt;

&lt;tr&gt;
  &lt;td height="10" background=""&gt;&lt;div align="right" class="style22"&gt;Report Refence Number: &lt;/div&gt;&lt;/td&gt;
  &lt;td width="243" height="10"&gt;&lt;label&gt;
    &lt;input name="Password" type="text" id="Password" onblur="" size="30"&gt;
  &lt;/label&gt;&lt;/td&gt;
  &lt;td width="98"&gt;&amp;nbsp;&lt;/td&gt;
&lt;/tr&gt;


&lt;tr&gt;
  &lt;td height="11" background=""&gt;&lt;label&gt;&lt;/label&gt;&lt;/td&gt;
  &lt;td height="11" background=""&gt;&lt;input name="Submit" type="submit" class="style22" value="View Report"&gt;&lt;/td&gt;
  &lt;td height="11" background=""&gt;&amp;nbsp;&lt;/td&gt;
 &lt;/tr&gt;
 &lt;/tbody&gt;&lt;/table&gt;
 &lt;/form&gt;
  &lt;/body&gt;
  &lt;/html&gt;
</code></pre>
