Form Postback not altering query

EDN Admin · Jul 13, 2012

I regularly code in Classic ASP but rarely in asp.net and so Im probably missing a basic step here. The Postback alters Message the but not the Query. Here is my code:
<%@ Page MasterPageFile="CairnAgency.master" AutoEventWireup="false" Title="The Cairn Agency Home Page" %> 
<script runat="server 
Sub SubmitBtn_Click(ByVal sender As Object, ByVal e As EventArgs) 
Message.Text = "Filter Applied - " 
If ClientTypeDd1.Text <> "" Then 
Message.Text = Message.Text & ClientTypeDd1.Text 
ClientTypeDd1.DataBind() 
End If 
If AgeRangeDd1.Text <> "" Then 
Message.Text = Message.Text & " aged " & AgeRangeDd1.Text 
AgeRangeDd1.DataBind() 
End If 
If AgeRangeDd2.Text <> "" Then 
Message.Text = Message.Text & "-" & AgeRangeDd2.Text & " years" 
AgeRangeDd2.DataBind() 
End If 
If HeightDdl.Text <> "" Then 
Message.Text = Message.Text & " and of height " & HeightDdl.Text 
HeightDdl.DataBind() 
End If 
If HeightDd2.Text <> "" Then 
Message.Text = Message.Text & "-" & HeightDd2.Text & "cm" 
HeightDd2.DataBind() 
End If 
If BuildDdl.Text <> "" Then 
Message.Text = Message.Text & " of " & BuildDdl.Text & " build" 
BuildDdl.DataBind() 
End If 
If HaircolourDdl.Text <> "" Then 
Message.Text = Message.Text & " with " & HaircolourDdl.Text & " coloured hair" 
HaircolourDdl.DataBind() 
End If 
If EyecolourDdl.Text <> "" Then 
Message.Text = Message.Text & " with " & EyecolourDdl.Text & " coloured eyes" 
EyecolourDdl.DataBind() 
End If 
If EthnicityDd1.Text <> "" Then 
Message.Text = Message.Text & " of " & EthnicityDd1.Text & " ethnic origin" 
EthnicityDd1.DataBind() 
End If 
End Sub 
</script> 
<asp:Content id="headertext" runat="server" contentplaceholderid="headtxt 
<h1>View the galllery of talent we have available</h1> 
<h3><asp:label id="Message" Text="Use these options to Filter Your Search Critera" runat="server"/></h3> 
<div class="selectionarea 
<asp:Label ID="ClientType" Text="Clyent Type:" runat="server" /> 
<asp

ropDownList ID="ClientTypeDd1" runat="server" DataSourceID="ClientTypeSelect" DataTextField="Client_Type" DataValueField="Client_Type" > 
<asp:ListItem>Please Select</asp:ListItem> 
</asp

ropDownList> 
 
<asp:Label ID="LowerAge" Text="Lower Age:" runat="server" /> 
<asp

ropDownList ID="AgeRangeDd1" runat="server" DataSourceID="ClientAgeSelect" DataTextField="Ages" DataValueField="Ages" /> 
<asp:Label ID="UpperAge" Text="Upper Age:" runat="server" /> 
<asp

ropDownList ID="AgeRangeDd2" runat="server" DataSourceID="ClientAgeSelectDesc" DataTextField="Ages" DataValueField="Ages" AutoPostBack="True" /> 
 
<div class="selectionarea 
<asp:Label ID="LowerHeight" Text="Lower Height:" runat="server" /> 
<asp

ropDownList ID="HeightDdl" runat="server" DataSourceID="ClientHeightSelect" DataTextField="Height" DataValueField="Height" /> 
<asp:Label ID="UpperHeight" Text="Upper Height:" runat="server" /> 
<asp

ropDownList ID="HeightDd2" runat="server" DataSourceID="ClientHeightSelectDesc" DataTextField="Height" DataValueField="Height" /> 
<asp:Label ID="Build" Text="Build:" runat="server" /> 
<asp

ropDownList ID="BuildDdl" runat="server" DataSourceID="ClientBuildSelect" DataTextField="Build" DataValueField="Build" /> 
 
<div class="selectionarea 
<asp:Label ID="Hair" Text="Hair Colour:" runat="server" /> 
<asp

ropDownList ID="HaircolourDdl" runat="server" DataSourceID="ClientHairSelect" DataTextField="Hair_Colour" DataValueField="Hair_Colour" /> 
<asp:Label ID="Eyes" Text="Eye Colour:" runat="server" /> 
<asp

ropDownList ID="EyecolourDdl" runat="server" DataSourceID="ClientEyesSelect" DataTextField="Eye_Colour" DataValueField="Eye_Colour" /> 
<asp:Label ID="Ethnicity" Text="Ethnic Origin:" runat="server" /> 
<asp

ropDownList ID="EthnicityDd1" runat="server" DataSourceID="ClientEthnicitySelect" DataTextField="Ethnic_Origin" DataValueField="Ethnic_Origin" /> 
 
<div class="selectionarea 
<asp:Label ID="Audio" Text="Voice Demos:" runat="server" /> 
<asp

ropDownList ID="AudioDdl" runat="server 
<asp:ListItem Text="All" Value="all </asp:ListItem> 
<asp:ListItem Text="Yes" Value="yes </asp:ListItem> 
<asp:ListItem Text="No" Value="no </asp:ListItem> 
</asp

ropDownList> 
<asp:Label ID="Video" Text="Show Reels:" runat="server" /> 
<asp

ropDownList ID="VideoDdl" runat="server 
<asp:ListItem Text="All" Value="all </asp:ListItem> 
<asp:ListItem Text="Yes" Value="yes </asp:ListItem> 
<asp:ListItem Text="No" Value="no </asp:ListItem> 
</asp

ropDownList> 
 
<asp:Button ID="filter" runat="server" Text=" Apply Filter " Width="140px"
 
PostBackUrl="~/NewVersion/clientlist.aspx"
 
ToolTip="Click to filter client records" onclick="SubmitBtn_Click" /> 
 
<asp:SqlDataSource ID="ClientTypeSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Client_Type FROM [qryClientTypeList]"
 
ProviderName="System.Data.SqlClient 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientAgeSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT CAST(CurrentAge as int) AS Ages FROM [qryClientAgeList]"
 
ProviderName="System.Data.SqlClient 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientAgeSelectDesc" runat="server"
 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT CAST(CurrentAge as int) AS Ages FROM [qryClientAgeList] ORDER BY CurrentAge DESC"
 
ProviderName="System.Data.SqlClient 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientBuildSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Build FROM [qryClientBuildList] 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientHeightSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Height FROM [qryClientHeightList] 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientHeightSelectDesc" runat="server"
 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Height FROM [qryClientHeightList] ORDER by Height Desc 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientHairSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Hair_Colour FROM [qryClientHairList] 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientEyesSelect" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT Eye_Colour FROM [qryClientEyesList] 
</asp:SqlDataSource> 
<asp:SqlDataSource ID="ClientEthnicitySelect" runat="server"
 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT [Ethnic_Origin] FROM [QryClientEthnicityList] 
</asp:SqlDataSource> 
</asp:Content> 
<asp:Content id="bodyContent" runat="server" contentplaceholderid="bodytxt 
<div class="light 
<asp:Repeater ID="Repeater1" runat="server" DataSourceID="ClientList"
 
DataMember="DefaultView 
<headertemplate> 
<ul class="clientrepeater 
</headertemplate> 
<itemtemplate> 
 
<asp:hyperlink ID="Hyperlink1" NavigateUrl=viewprofile.aspx?id=<%# Eval("Online_ClientID")%> CssClass=center runat=server> 
<asp:image id="ClientImage" 
imageurl=<%# "/files/images/" & Eval("Image_URL") %> CssClass=barepic 
alternatetext=<%# Eval("Full_Name") %>
 
runat="server"/> 
 
<%# Eval("Full_Name")%> 
 
<%# Eval("Client_Type")%></asp:hyperlink>
 
 
</itemtemplate> 
<footertemplate> 
 
</footertemplate> 
</asp:Repeater> 
 
<asp:SqlDataSource ID="ClientList" runat="server" 
ConnectionString="<%$ ConnectionStrings:CAconnectionString %>"
 
SelectCommand="SELECT [Online_ClientID], [Full_Name], [Client_Type], [Image_URL], [Image_Heading] FROM [qryClientWebList] WHERE (([IsDefaultImage] = @IsDefaultImage) AND ([Client_Type] LIKE @Client_Type) AND
([CurrentAge] >= @CurrentAge) AND ([CurrentAge] <= @CurrentAge2) AND ([Height] >= @Height) AND ([Height] <= @Height2) AND ([Hair_Colour] LIKE @Hair_Colour) AND ([Eye_Colour] LIKE @Eye_Colour) AND ([Build] LIKE @Build) AND ([Ethnic_Origin]
LIKE @Ethnic_Origin)) 
<SelectParameters> 
<asp

arameter DefaultValue="true" Name="IsDefaultImage" Type="Boolean" /> 
<asp:FormParameter DefaultValue="%" FormField="ClientTypeDd1.Text" Name="Client_Type" Type="String" /> 
<asp:FormParameter FormField="AgeRangeDd1" DefaultValue="0" Name="CurrentAge" Type="Decimal" /> 
<asp:FormParameter FormField="AgeRangeDd2" DefaultValue="130" Name="CurrentAge2" Type="Decimal" /> 
<asp:FormParameter FormField="HeightDdl" DefaultValue="0" Name="Height" Type="Int32" /> 
<asp:FormParameter FormField="HeightDd2" DefaultValue="3000" Name="Height2" Type="Int32" /> 
<asp:FormParameter FormField="HaircolourDdl" DefaultValue="%" Name="Hair_Colour" Type="String" /> 
<asp:FormParameter FormField="EyecolourDdl" DefaultValue="%" Name="Eye_Colour" Type="String" /> 
<asp:FormParameter FormField="BuildDdl" DefaultValue="%" Name="Build" Type="String" /> 
<asp:FormParameter FormField="EthnicityDd1" DefaultValue="%" Name="Ethnic_Origin" Type="String" /> 
</SelectParameters> 
</asp:SqlDataSource> 
</asp:Content>
I want the queery in this to be updated using the form inputs on post back. Can you spot what is stopping that from happening?
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <hr class="sig Brian Watson

View the full article

Form Postback not altering query

EDN Admin

Well-known member

Similar threads