FilterExpression and the SQLDataSource Control- returns ALL values

[sm2010]

Hi,

I have a SQLDatasource control on a web page. It is the datasource for a gridview control.


At the moment i have in the contractID and duration text property the symbol '%', however If I make the TextBox empty or remove the % from the contractID and duration Textbox it returns all the names in the database when i first run the script.

How do I get the gridview to be blank when i first run the script without having to use the % in the Textboxes?

MANY THANKS!

<form id="form1" runat="server"> 
<div>
</div> 
<br /> 
 
<asp:TextBox ID="contractID" runat="server">%</asp:TextBox> 
<asp:TextBox ID="duration" runat="server">%</asp:TextBox> 
<asp:Button ID="Button1" runat="server" Text="Button" /> 
 
<br /> 
 
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="contractID"> 
<Columns> 
  <asp:BoundField DataField="contractID" HeaderText="contractID" ReadOnly="True" SortExpression="contractID" /> 
  <asp:BoundField DataField="duration" HeaderText="duration" SortExpression="duration" /> 
  <asp:BoundField DataField="noOfHourse" HeaderText="noOfHourse" SortExpression="noOfHourse" /> 
</Columns>
</asp:GridView> 
 
<br /> 
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Contract]" FilterExpression="contractID LIKE '{0}%' AND duration LIKE '{1}%'" 
EnableCaching="true" DataSourceMode="DataSet"> 
  <FilterParameters> 
    <asp:ControlParameter ControlID="contractID" DefaultValue="%" Name="contractID" ConvertEmptyStringToNull="false" /> 
    <asp:ControlParameter ControlID="duration" DefaultValue="%" Name="duration" ConvertEmptyStringToNull="false" /> 
 
  </FilterParameters> 
</asp:SqlDataSource>

[Frinavale]

Have you tried removing the "%" from the DefaultValue fields?
The "%" character is a wildcard character that matches any string with zero or more characters. It will return everything.

-Frinny