DropDownList, DataSource and Selected Items

kingroon · February 20th, 2008, 11:28 AM

Hi,

If I have a SQL DataSource as the data source for a DroDownList [as below], and within this page I have called a record from the DB that relates to this drop down list [but only one value] how do I ensure that /that/ value is selected?

##################### CODE #####################

<asp:DropDownList ID="ddlTowns"
    runat="server"
    DataSourceID="dataTowns"
    DataTextField="GT_Name"
    DataValueField="GT_ID">
</asp:DropDownList>

<asp:SqlDataSource ID="dataTowns"
    runat="server"
    ConnectionString="<%$ ConnectionStrings:dbConn %>"
    SelectCommand="townsSelect"
    SelectCommandType="StoredProcedure">
</asp:SqlDataSource>

##################### END OF CODE #####################

I'm guessing I have to write some code in the aspx.cs file such as

##################### ASPX.CS #####################

protected void Page_Load(object sender, EventArgs e)
    {
        this.ddlTowns.SelectedIndex = ...
    }

##################### END OF ASPX.CS #####################

Any help greatly appreciated..

Can anyone point me in the direction of a great resource for this sort of thing?

Cheers..

Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.
http://www.dogfightclothing.com

chroniclemaster1 · February 22nd, 2008, 11:08 PM

I believe you're doing everything correctly. All you need to do is reference the single value you're pulling. Is it the Stored Procedure doing that? or is it in a form control. That's what's going onto the other side of your expression in the .cs file. How are you getting that value?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

kingroon · February 25th, 2008, 10:41 AM

Hi, yeah I know /what/ I have to do I think, I just don't know the syntax! :oS

How do I reference the Data from the DataSource in the .aspx.cs page? If the logic is that I want the townID from dataTowns i.e. in this bit:

this.ddlTowns.SelectedIndex = ...

Hasta Luego..
KingRoon

DogFightClothing. No dogs. No fighting.
http://www.dogfightclothing.com