Dynamic dropdownlist for every selection

Question

johny2011 0 Newbie Poster

13 Years Ago

Hi all,
I have two dropdownlist (country and city dropdownlists) taking their data from access database, in order for filtering the data shown in gridview.

I want city dropdownlist get notified and change whenever a country selected from country dropdown list

I mean, wheneever user selects a country, I want city dropdownlist to show only cities only from the selected country

Right now I only use ASP NET (behind code),
In order to make that dynamic dropdownlist, do I hav to write c# code ?
can someone show how cna I do it with ASP NEt or c#?

Thanks!

And here is my full ASP NET code

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head profile="http://gmpg.org/xfn/11">
<title>Untitled Page</title>
    <link rel="stylesheet" type="text/css" href="gridview.css" media="all" />

</head>
<body>
    <form id="form1" runat="server">

    <asp:ScriptManager ID="ScriptManager" runat="server" />
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
        <h3>Gridview with Filtering</h3>
            <div class="GridviewDiv">
            <table style="width: 540px" border="0" cellpadding="0" cellspacing="1" class="GridviewTable">
                <tr >

                    <td onmouseover="this.style.background='red';this.style.cursor='pointer'"
        onmouseout="this.style.background='orange';" onclick="City='http://www.google.com'">
        ID </td>                    

                    <td style="width: 120px;" >
                        First Name
                    </td>
                    <td style="width: 120px;">
                        Last Name
                    </td>
                    <td style="width: 130px;">
                        Country
                    </td>

                    <td style="width: 130px;">

                        City
                    </td>



                </tr>
                <tr >
                    <td style="width: 40px;" >

                    </td>

                    <td style="width: 120px;">
                        &nbsp;</td>
                     <td style="width: 130px;">
                         &nbsp;</td>

                    <td style="width: 130px;">
                        <asp:DropDownList ID="ddlCountry" runat="server" AppendDataBoundItems="true" 
                            AutoPostBack="true" DataSourceID="dsPopulateCountry" 
                            DataValueField="Country" Font-Size="11px" Height="16px" Width="120px">
                            <asp:ListItem Text="All" Value="%"></asp:ListItem>
                        </asp:DropDownList>
                    </td>
                    <td style="width: 130px;">
                        <asp:DropDownList ID="ddlCity" runat="server" AppendDataBoundItems="true" 
                            AutoPostBack="true" DataSourceID="dsPopulateCity" DataValueField="City" 
                            Font-Size="11px" Width="120px">
                            <asp:ListItem Text="All" Value="%"></asp:ListItem>
                        </asp:DropDownList>
                    </td>
                </tr>
                <tr>
                    <td colspan="5">
                        <asp:GridView 
                        ID="Gridview1" 
                        runat="server" 
                        AutoGenerateColumns="False" 
                        AllowPaging="True"
                        AllowSorting="true" 
                        DataSourceID="dsGridview" 
                        Width="540px" 
                        PageSize="10" 
                        CssClass="Gridview"
                        onrowdatabound="gdvPeople_RowDataBound">  
                            <Columns>

            <asp:hyperlinkfield headertext="Title"
            datatextfield="id"
            datanavigateurlformatstring="title_details.aspx?titleid={0}"
            datanavigateurlfields="id" />
                                <asp:BoundField DataField="id" HeaderText="Sırala" SortExpression="id" ItemStyle-Width="40px"
                                    ItemStyle-HorizontalAlign="Center"  />
                                <asp:BoundField DataField="FirstName" HeaderText="Sırala" SortExpression="FirstName"
                                    ItemStyle-Width="120px" />
                                <asp:BoundField DataField="LastName" HeaderText="Sırala" SortExpression="LastName"
                                    ItemStyle-Width="120px" />
                                <asp:BoundField DataField="Country" HeaderText="Sırala" SortExpression="Country"
                                    ItemStyle-Width="130px" />
                                <asp:BoundField DataField="City" HeaderText="Sırala" SortExpression="City"
                                    ItemStyle-Width="130px" />
                            </Columns>
                        </asp:GridView>
                    </td>
                </tr>
            </table>
            </div>

            <asp:AccessDataSource ID="dsGridview" runat="server" DataSourceMode="DataSet"
            DataFile="Database2.mdb" 

            SelectCommand="SELECT * FROM T_Employees"
FilterExpression="Country like '{0}%'  and City like '{1}%' ">
                <FilterParameters>
                    <asp:ControlParameter Name="Country" ControlID="ddlCountry" PropertyName="SelectedValue" />
                    <asp:ControlParameter Name="City" ControlID="ddlCity" PropertyName="SelectedValue" />

                </FilterParameters>
            </asp:AccessDataSource>


            <asp:AccessDataSource ID="dsPopulateCountry" runat="server" DataFile="Database2.mdb"  
                SelectCommand="SELECT DISTINCT Country from T_Employees"></asp:AccessDataSource>
            <asp:AccessDataSource ID="dsPopulateCity" runat="server" DataFile="Database2.mdb"  
                SelectCommand="SELECT DISTINCT City FROM T_Employees"></asp:AccessDataSource>
            <asp:AccessDataSource ID="dsPopulateFirstName" runat="server" DataFile="Database2.mdb"  
                SelectCommand="SELECT DISTINCT FirstName FROM T_Employees"></asp:AccessDataSource>
             <asp:AccessDataSource ID="dsPopulateLastName" runat="server" DataFile="Database2.mdb"  
                SelectCommand="SELECT DISTINCT LastName FROM T_Employees"></asp:AccessDataSource>
            </div>
        </ContentTemplate>
    </asp:UpdatePanel>
    </form>
</body>
</html>

asp.net

Edited 11 Years Ago by mike_2000_17 because: Fixed formatting

3 Contributors
12 Replies
504 Views
5 Days Discussion Span
Latest Post 13 Years Ago Latest Post by johny2011

stbuchok

13 Years Ago

Have a selected event on the country dropdown that gets fired when someone changes what is selected. Now when the event fires, it looks to see what is selected and pulls the information from the database and fills the cities dropdown with the relevant data.

croker10 0 Junior Poster in Training

13 Years Ago

Johny2011,
I'm not familiar with a method of doing this without using code, however, take that with a grain of salt, as I'm not a fan of doing everything on the asp page, seperating with a code file makes for cleaner asp markup and code pages, in my humble opinion.

That said, using a code behind would be quite simple.

add a little to your Country Drop Down List:

<asp:DropDownList ID="ddlCountry" runat="server" 
AutoPostBack="true" OnSelectedIndexChanged="PopulateCitiesDropDown" Font-Size="11px" Height="16px" Width="120px">

(note the wrapping of code in code tags, makes it look nice and easy to read!)

Then in your code behind, add some simple code

proteced void PopulateCitiesDropDown(Object countryDropDown, EventArgs e)
{
//in here is where you populate the data.  you can do some really cool stuff with drop downs and bindings, but I wont go into more detail
string Country = ddlCountry.Text;
//use the country value to find what you need
}

The gist inside the code behind is to create a set of data to populate the drop down.

Here's a good website to demonstrate.

Again, there may be a method to do this without, code behind, but I am not aware of it. Hope it helps, let me know if I can be of any other use!

stbuchok

13 Years Ago

Doing a query through a database with a few thousand records is nothing. A database is there to store and search, so use it. Fill the country dropdown with all the countries available in the DB, once you select a country populate the cities dropdown based on the country selected.

Also if you have the data in a DataTable object you can query the DataTable the same way.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

johny2011 0 Newbie Poster · Answer 1 · 2011-06-08T21:42:33+00:00

Do I have to make a query on the database for every time am event happens,
or can I use gridview for updating dropdownlist ?

Can you provide a litle code for this ?

johny2011 0 Newbie Poster · Answer 2 · 2011-06-09T17:20:59+00:00

Thanks but still confused, you did not reply my exact quetions. let me clarify it.

When the page loads, both drowdownlists show all contents from country and city columns of the database table. I mean, all the data already includeded, as "All" in the dropdownlist.

When usser selects a Country, how will I do hanle it in behind code ?

Make a query to populate city dropdownlist list from a tha database where country equals the selected country (this means search all table again which is has thousadn of records)

Or, just make a query on the gridview (remember all the data called before)
If so, How can I make query on grid view ?

croker10 0 Junior Poster in Training · Answer 3 · 2011-06-09T19:49:50+00:00

Sorry that I missed that, but yes as stbuchok mentioned, a query of thousands of records is really nothing. A decent, not even great query should run in a second or so.

That will really be the least of your overhead time, when you get into the millions of records is when your queries start to matter and run time of queries affects performance.

Moral of the story, don't be concerned with a simple database query or two.

johny2011 0 Newbie Poster · Answer 4 · 2011-06-09T22:03:18+00:00

Thank you all.
At this point, I want ot ask another question. I am using access database.

And I am confusedwant to make all operations which operations to handle qith a query, and which operations handle with filtering.

Actually I want to load all database for at once bcos it will be big, and load it once and use filters..

On the other side,
for filtering for every dropdownlist selection I need to query db again,
is it realy performance or I miss something here.

stbuchok · Answer 5 · 2011-06-10T00:44:30+00:00

Doing it that way is a waste. What happens if your DB gets to be 500MB, are you going to load all 500MB into memory. NO FOR THE LOVE OF GOD, DON'T DO IT THIS WAY!!!!!!!!!!
The performance gain you will get will be so insignificant that it is completely not worth doing it that way. Please, please, please, just query the database each time. Each query will be considerably less than a second. Also look into using a real database and try to get out of using Access. MS SQL Express is free and considerably more powerful, hell you can even use MySQL.

johny2011 0 Newbie Poster · Answer 6 · 2011-06-10T18:58:10+00:00

OK stbuchok, pelase do not get angry with me, I will follow the way you adviced.

The problem is that I am new to ASP NEt and c#, and I am still confused at some points

if you will handle seleciton in behin the code,
then I need to write all db connection codes in the behind code right, not in ASp right ?

I mean I need to write whole db code in c # and bypass the ASP NET..

Can you help me doing it ? I know how to connect to db in c# in form application, but I never connected to db and used dropdownlist from ASP NET in c# for an ASP NET site ?

What is the way I need to follow ? Can you provide a little code sample for this. Thanks in advance.

croker10 0 Junior Poster in Training · Answer 7 · 2011-06-10T19:33:56+00:00

Johny2011,

Please take a look at the website I linked to above. It is a basic tutorial on populating a dropdown with a database connection and should answer most of your questions. Assuming you're partially familiar with queries and such, it should not be difficult to adapt to your specific needs.

As stbuchok mentioned, use of a more powerful database would be a good idea.I have used SQL Express many times and like it a lot.

Any further questions should probably go in a new thread if you can't find the answer yourself.

stbuchok · Answer 8 · 2011-06-10T20:07:30+00:00

LOL, I wasn't getting angry I just wanted to emphasize not to do it that way. Sorry if it came across that way.

This is one way to populate a dropdownlist:
http://www.dbtutorials.com/advanced/populatingdropdown-csharp.aspx

My preferred way is to create business objects and use the business objects, but that is just me, this way can be fine too.

johny2011 0 Newbie Poster · Answer 9 · 2011-06-13T16:55:45+00:00

Hi, Thanks a lot for useful advices and links.
stbuchok, the zip file in the site you have sent its link, does not contain a working example, I think something is corrupt in that.And Croker10, there is no link in your post ??

Please I have a final question on this issue,
Actually I have a full working example with filtering (which uses no behind code)
and I want to update is.

I heard that it is possible to use ASP.NET form elements.

What Iwant to do is;
Remember the first code I have post
code for sql query;
<asp:AccessDataSource ID="dsPopulateCity" runat="server" DataFile="Database2.mdb" SelectCommand="SELECT DISTINCT City FROM T_Employees"></asp:AccessDataSource>
I wanto to repopulate dropdownlist from this query,

code for populationg dropdownlist

<asp:DropDownList ID="ddlLocation" runat="server" AppendDataBoundItems="true"
AutoPostBack="true" DataSourceID="dsPopulateLocation" DataValueField="location" ...

Here is the query I want to get worked when a Country selected from the country dropdownlist;

SelectCommand="SELECT DISTINCT City FROM T_Employees WHERE City='selectedCountry'">

I mean, in behind code event handler, I wanto to recall those sql query and populating ASP NET code, and populate my city dropdownlist with new query.
(and query will take selected valua of country dropdownlist)

Can anyone can provide a simple code for it ? Sory for taking your time. Thanks..