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.......