asp.net dropdownlist

Question

I have two dropdownlists for a search, the 1st list is for the city and the second is for the area within the selected city. I would like to add a default value in the 2nd dropdownlist that will search ALL of the areas by default unless a specific area is selected from the list that contains the areaID for a specific search.

 <asp:DropDownList ID="DropDownList1" runat="server" 
DataSourceID="SqlDataSource1" DataTextField="cityName" AutoPostBack="true" DataValueField="cityID">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
SelectCommand="SELECT * FROM [Cities]"></asp:SqlDataSource>
<asp:DropDownList ID="DropArea" runat="server" DataSourceID="SqlArea" 
    DataTextField="areaName" DataValueField="areaID">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlArea" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    SelectCommand="SELECT * FROM [area] WHERE ([cityID] = @cityID)">
    <SelectParameters>
        <asp:ControlParameter ControlID="DropDownList1" DefaultValue="0" Name="cityID" 
            PropertyName="SelectedValue" Type="Int16" />
    </SelectParameters>
</asp:SqlDataSource>
    <asp:Button ID="Button1" runat="server" Text="Search" onclick="Button1_Click" />

I would like to add a default value in the 2nd dropdownlist that will search ALL of the areas by default — Chris
– Chris, Commented Dec 10, 2010 at 23:37

XtremeBytes · Accepted Answer · 2010-12-10 23:39:04Z

1

Bind the second from code behind. Create a data table and insert the Select text at the begining and bind the datatable to the DDL. DataTable dt = DataRow dr = dt.NewRow() dr["areaName"] = "All"; dr["SqlArea"] = "All"; tbldata.Rows.InsertAt(dr,0);

DropArea.DataSource = dt; DropArea.DataBind();

answered Dec 10, 2010 at 23:39

XtremeBytes

1,5078 silver badges12 bronze badges

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

1 Comment

joelt Over a year ago

Heck, bind both from code-behind. The <asp:xxxDataSource controls are a crazy idea.

Dima Shmidt · Accepted Answer · 2010-12-11 00:08:13Z

0

You can try to add for second dropdownlist OnDataBound="DropArea_DataBound" event.

And use in code:

protected void DropArea_DataBound(object sender, EventArgs e)
{
    DropArea.Items.Insert(0, new ListItem() {Value = "-1", Text = "ALL"});
}

And then when you handle click event, check:

var value = DropArea.SelectedItem.Value;
if(string.equals(value, '-1')
{
   use your logic here
}

Hope it will help with your problem.

Best regards, Dima.

edited Dec 11, 2010 at 0:08

answered Dec 10, 2010 at 23:52

Dima Shmidt

9054 silver badges13 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:03:28Z

0

Chris,

I got the idea below from an answer HERE, but basically you want to modify your query to be in the form of the following:

Your Original:

SELECT * FROM [Cities]

Change To:

SELECT City FROM [Cities]
UNION ALL
SELECT 'ALL'

Old question, but you never found an answer.

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Oct 29, 2012 at 19:10

user153923

Collectives™ on Stack Overflow

asp.net dropdownlist

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related