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

Answer 1

hi friend,
Here is your code:

Take a dropdownlist on you aspx page

<asp:DropDownList ID="DropDownList1" runat="server" EnableViewState="true">

    </asp:DropDownList>

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.

Answer 2

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.

Answer 3

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