Remove parameter from sqldatasource

Question

I want to populate dropdownlist according to Date

  <asp:DropDownList ID="ddlNewJobOrder" DataTextField="name" DataValueField="value"
                                                        runat="server" AppendDataBoundItems="True" DataSourceID="NewJobOrderDS" ToolTip="New Job Order List" Width="110" AutoPostBack="True" OnSelectedIndexChanged="ddlNewJobOrder_SelectedIndexChanged">
  <asp:SqlDataSource ID="NewJobOrderDS" runat="server" SelectCommand="SELECT Ref_No as name, Job_Order_ID as value FROM Job_Order WHERE Status <> 'JO_Completed' and Delivery_Date = @jaDate1 ORDER BY Ref_No" OnSelecting="NewJobOrderDS_Selecting">
 <SelectParameters>
 <asp:ControlParameter ControlID="JADate1" Name="jaDate1" PropertyName="Text" Type="DateTime"/>                                
 </SelectParameters>

so each time Date is changing,then the DDL should be re-populate again.

SqlDataSource1.SelectParameters.Remove(SqlDataSource1.SelectParameters["jaDate"]);
            SqlDataSource1.SelectParameters.Add("jaDate", JADate2.Text);

but the above code is not working, the DDL has no response after the 1st time I populate it.

how you bind JADate2? what is the value member and display member? try with PropertyName="SelectedValue" instead of PropertyName="Text" — Damith
– Damith, Commented Aug 12, 2013 at 4:06

Magnus Bertilsson · Accepted Answer · 2013-08-12 07:02:47Z

1

There must be a postback the change the content of the dropdown and the textbox wont postback on its own. So you must add a button or use javascript to postback the form after someone entered text in the textbox.

answered Aug 12, 2013 at 7:02

Magnus Bertilsson

6154 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Remove parameter from sqldatasource

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related