How to select item based on value in ASP.Net DropDownList which is bind from database

nedash

i have drop down list in my page that contain cities name i bind it from city table

i want when page is load in my dropdown list show name of city from House_p table it is different for each users

city	behcode	name	id
paris	1111	sara	1

i bind txtstore.Text = _dr["name"].ToString();

that show name column in text box now i want bind dropdownlist that show city column

thanks again

vinayak

0 3

select drop down by using following code

ddlCountry.Items.FindByValue(dr["name"].ToString()).Selected = true;

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html