Hi,

I am using a dropdownlist, textbox and a gridview.

i have populated the dropdownlist with the country codes from a table. based on the selection of the country code i am populating the grid with appropriate values. the drop down list contains codes like 'US','SA','UK','IND','AUS' fetched from the query "SELECT PrmCde,PrmVal from PrmDef"

PrmCde is the Country Code and PrmVal is the description of the Country like United states, South Africa, United Kingdom, India etc...

What I am looking for is to set the initial value of the dropdown list to IND and the textbox should display India. On change of the dropdown list value the text box value should change accordingly. I am using Sqldatasource. Any help or alternative to this issuw will be highly appreciated.

Thanks

Steve

Try this:-

DropDownList1.Items.FindByValue("IND").Selected = true;

Marks as answer, if so

Two solutions:

1st method

Add a prmSequence column to the table with country codes, set sequence to 1 on India record, 2 (or anything higher) on other records.

"Select prmCode, prmVal from prmDef order by prmSequence, prmCde"

2nd method

In the asp tags, add a first line for India and specify AppendDataItems so that values from the database will be added to the existing value, instead of overwriting it.

Note that if India is also in the list read from the database, it will appear twice in the DDL, unless you change the sql to include " ... where prmCde <> 'IND' "

<asp:DropDownList ID="ddlCountry" DataSourceId="sdsCountry" DataTextField="prmCde" DataValueField="prmVal" >

<asp:ListItem Value="IND" Text="India" />