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.

SARAVANA PERUMAL · Answer

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

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.