FIlter expression not working Sqldatasource

Question

This is my sqldatasource with filter expression

   <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    SelectCommand="SELECT [id], [title], [client], [projectmanager], [project_scope], [project_materials], [project_gating], [project_cavities], [project_file], [project_otherdetails], [priority], [commodity], [status], [start_date], [end_date] FROM [project_details]" 
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                    EnableCaching="True" CacheDuration="1000" 
FilterExpression="title= '{2}'">



 <FilterParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="mainsearch" 
                        PropertyName="SelectedItem.Value" />
                    <asp:ControlParameter ControlID="TextBox2" Name="start_date" 
                        PropertyName="Text" />
                    <asp:ControlParameter ControlID="TextBox3" Name="end_date" 
                        PropertyName="Text" />
    <asp:ControlParameter   

                                  </FilterParameters>



    </asp:SqlDataSource>

when i enter the value in Textbox2 it is not working what might be the problem

Please don't ask the same questions again. Edit your first question. — Neil Knight
– Neil Knight, Commented Jul 6, 2011 at 13:48
sorrry will do in future.do you have any solution for this question — saurabh goyal
– saurabh goyal, Commented Jul 6, 2011 at 13:50

Muhammad Akhtar · Accepted Answer · 2011-07-06 14:20:59Z

1

Because you set the ControlID="TextBox1" in your SQL DataSource SelectParameters, but you are setting the value in Textbox2. You have to change it to <asp:ControlParameter ControlID="TextBox2"

<asp:ControlParameter ControlID="TextBox2" DefaultValue="%" Name="title" 
            PropertyName="Text" Type="String" />

Edit: Following your comments, you want to clear the Where Clause. You can do like...

protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
    SqlDataSource1.SelectParameters.Clear(); // First Clear the Selected parameters
    SqlDataSource1.SelectCommand = "SELECT [id], [title], [client], [projectmanager], [project_scope], [project_materials], [project_gating], [project_cavities], [project_file], [project_otherdetails], [priority], [commodity], [status], [start_date], [end_date] FROM [project_details]";
}

edited Jul 6, 2011 at 14:20

answered Jul 6, 2011 at 13:59

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

saurabh goyal Over a year ago

select parameter is not related to filter parameter .the select parameter is for where statement

Muhammad Akhtar Over a year ago

I am talking for where statement.

saurabh goyal Over a year ago

but my question is about filter expression .remove the where statement from the code.after that it also not working .

Muhammad Akhtar Over a year ago

You want to remove filteration expression or Where Clause from your query ?

saurabh goyal Over a year ago

filter expression sucks now i am working with where clause to solve the problem

Collectives™ on Stack Overflow

FIlter expression not working Sqldatasource

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related