hello,
I have two problem with drop down box. These are...

1. I have two tables. One is country_master and other is user_master. In the user registration form, there is a drop down box for countries which I'm filling from the country_master table and it is running well. Now I want a "---Select---" entry at the beginning of drop down box. How I can do this?

2. I am storing the country_id in the user_master table. User can edit there profile. Now when user open the profile for editing the entire form is filled with old values. Now the problem is that how I can show the last selected country name in the drop down box?
By the way I am new in .net. Please help me.
regards,

__________________
Angshujit

soln:
1)You have to set "selected" property for "---Select---" as true in <asp:Dropdownlist> tag.
2)select country_id and accordingly depending on this id set "selected" property true for that country_id

I think this is right

Hi Amit,

Could you please check this, as I think this way its not possible if you are using a ASP.net component combo box?


Cheers!

Debashis

hi amit

thanks for reply. But I think I cannot make you understand my problem. So I am sending you my code :

Here is the code for .aspx file (only drop down box) -
<asp:dropdownlist id="lstCountry" DataValueField="country_id" DataTextField="country_name" Runat="server"></asp:dropdownlist>

And here is the code for C# file ('con' is the connection object)-
SqlDataAdapter da = new SqlDataAdapter("Select * from country_master", con);
DataSet ds = new DataSet();
da.Fill(ds, "country");
lstCountry.DataSource = ds.Tables["country"];
lstCountry.DataBind();

Now how and where i should use 'selected' option ?
Angshujit

use this to insert ---Select--- at start of list

lstCountry.DataSource = dsProducts;
lstCountry.DataBind();
lstCountry.Items.Insert(0, new ListItem("---Select---"));

Regards,
Rashida Jabeen
http://www.akaas.net

hello, iamrashida83

Thank you for your help. It is working fine. Please help me to solve my second problem. That is in the time of editing, I want to display the previously selected country in the drop down box. How I can select that ? I am storing the country_id in the user_master table.

Please help me.
Angshujit

@angshujit:

it depends on ur DB design
are u storing countryid or country name in user_master table?

better way is to store countryid of selected country in the matser table. To load previous values select all values from table and get it in a datatable suppose dtMember

u have to bind countries in dropdownlist like:
lstCountry.DataSource = dtCountries;
lstCountry.DataTextField = "CountryName"; //name of column of data table
lstCountry.DataValueField = "CountryID" //name of column of data table
lstCountry.DataBind();
lstCountry.Items.Insert(0, new ListItem("---Select---"));

now while loading the users u can sleect the country from dropdownlist using the id of country stored in user_master table

so try this

lstCountry.SelectedValue = ---- // country id u fetched from member's table

Regards,
Rashida Jabeen
http://www.akaas.net

Hello Rashida Jabeen,

Thanks for your help. It is working fine.

Angshujit