about dropdownlist

[Rajeshwar Code Developer]

here the thing is i was many countries binding to ddl frm countries table .. so there is one more table called userdetails. for one user having one country right .. i want show automatically his country inj ddl.

try and try untill reach success..

[Abhijit Jana]

This is my Dropdownlist. [ I assume you are binding it from Database.

us
india
koria
canada

[ I have removed / for formatting. ] In page load I am using this,

protected void Page_Load(object sender, EventArgs e)
{
DropDownList1.SelectedValue = "india";
}

Here rather than india, you should use the value of user country.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article

[Rajeshwar Code Developer]

thanks abhijith !!! See my code one.. ddlCountry.SelectedValue = ds.Tables[0].Rows[0]["sCountry"].ToString(); am doing like this ? in Selectedvalue showing null value.

try and try untill reach success..

[Suresh Suthar]

Rajeshwar First bind the ddlCountry with your country table data and than use below mentioned code to select user's country.

ddlCountry.ClearSelection()
ddlCountry.Items.FindByText("user's country").Selected = True

Be an Eagle, Sky is Yours.

[Rajeshwar Code Developer]

still there is no result..

try and try untill reach success..

[Abhishek Sur]

When page loads, first Bind the Data with the dllCountry. Choose appropriate DataTextField and DataValueField. Now after you finish your load using DataBind, use this.dllCountry.SelectedValue with the DataValueField you want. Also please check if you have wrote If(IsPostBack)return; in the Form_Load, so that when the page is posted back the selection remains. :thumbsup:

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Abhijit Jana]

Abhishek Sur wrote:

Choose appropriate DataTextField and DataValueField.

I guess he is missing bind with DataValueField :)

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article

[Abhishek Sur]

yes... right. If DataValueField is not specified, the value will be same as DataTextField. I personally always set ID as value so that I could set SelectedValue with some numeric field or GUID, as TextField may repeat. :rose:

Abhishek Sur

---

My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB

**Don't forget to click "Good Answer" if you like to.

[Rajeshwar Code Developer]

thnks for all who reply me .. i tried like this also bu there is no output.. and this is my code if (!IsPostBack) { DataSet ds1 = new DataSet(); ds1 = ad.dsGetvalues("Select * from Countries", true); ddlCountry.DataSource = ds1; ddlCountry.DataTextField = "sCountryName"; ddlCountry.DataValueField = "sno"; ddlCountry.Items.Insert(0, "--Select--"); ddlCountry.DataBind(); DataSet dss = new DataSet(); dss = ad.dsGetvalues("select * from UserDetails where PkiUsername ='"+Session["Username"].ToString()+"' ", true); ddlCountry.SelectedValue = dss.Tables[0].Rows[0]["sCountry"].ToString(); }

try and try untill reach success..

[Abhijit Jana]

Rajeshwar Code- Developer wrote:

ddlCountry.DataValueField = "sno";

Try this

ddlCountry.DataTextField = "sCountryName";
ddlCountry.DataValueField = "sCountryName";

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article