filtering gridview not working

[newbieAl]

I have two drop down lists to use as a filter for a gridview. This is what the select command in the gridview's datasource looks like:

SelectCommand="SELECT * FROM [datatable] WHERE ([afield] = @afield) OR ([bfield] = @bfield) ">
<selectparameters>

Type="String" />

Type="String" />
</selectparameters>

The filtering is not working for the second control. Bfield does not filter the data.

 

[tperri]

Can you please provide all of the code for this functionality so we can better assist you?

Thanks

 

[newbieAl]

Dropdown lists:

<aspropDownList ID="DropDownList1" runat="server" AutoPostBack="True" >
<asp:ListItem>Select an item</asp:ListItem>
<asp:ListItem>A</asp:ListItem>
<asp:ListItem>B</asp:ListItem>
</aspropDownList><br /><br />

<aspropDownList ID="DropDownList2" runat="server" AutoPostBack="True">
<asp:ListItem>Select an item</asp:ListItem>
<asp:ListItem>Closed</asp:ListItem>
<asp:ListItem>Open</asp:ListItem>
</aspropDownList>


Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If DropDownList1.SelectedIndex.Equals(0) Then
datatable.SelectCommand = ("SELECT * FROM

")
GridView1.DataBind()

End If

End Sub

 

[jbenson001]

My suggestions:
Get away from the datasource controls. They cause too many issues once you get away from a simple query.
Write stored procedures. They are quicker, reuseable and easily maintained.

 

[newbieAl]

Thank you, you are correct and that is my plan to move to sp's however what I am encountering is a filtering issue and would need assistance with that.

 

[newbieAl]

Here is my sqldatasource info (I noticed it didn't post properly the first time):

SelectCommand="SELECT * FROM [datatable] WHERE ([afield] = @afield) OR ([bfield] = @bfield) ">

SelectParameters
ControlParameter ControlID="DropDownList1" Name="afield" PropertyName="SelectedValue" Type="String" />
ControlParameter ControlID="DropDownList2" Name="bfield" PropertyName="SelectedValue" Type="String" />
SelectParameters>