show the database data in dropdown list

Question

I am developing the 3-tier architecture.... I finished my database parts. In my database i have country as a table that contains countrycode,countryname field.I insert some data's in that table.. my problem is i want to show the countrycode items only in presentation layer using dropdownlist..... any body give idea for me..........................

Thanks......

Amit Choudhary · Answer

hi friend, Here is your code: Take a dropdownlist on you aspx page in your code behind write following code on page_load event: protected void Page_Load(object sender, EventArgs e) { SqlConnection cn = new SqlConnection("pass your Connction string here"); cn.Open(); SqlDataAdapter adp = new SqlDataAdapter("select countryid, countryname from countrytable", cn); DataTable dt = new DataTable(); adp.Fill(dt); DropDownList1.DataSource = dt.DefaultView; DropDownList1.DataBind(); DropDownList1.DataValueField = "countryid"; DropDownList1.DataTextField = "courtryname"; } Please don't forget to mark as answer.

Amit Choudhary · Answer

hi friend, in asp.net control you can achieve it like this.... Data ds=Countries.getCountries(); DDcountries.DataSource=ds; DDcountries.DataBound; DDcountried.Value="CountryName"; DDcountries.Item="CountryCode"; Please mark as answer if it helps you.

SARAVANA PERUMAL · Answer

Thanks for ur reply.... if u have any coding plz send me.......

show the database data in dropdown list

Vikrant More