How to display Data in DropDown List

Hi

public List disp_rec()
        {
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            SqlCommand cmd = new SqlCommand("disp_org", con);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataReader dr = cmd.ExecuteReader();
            List obj = new List();
            while (dr.Read())
            {
                nsBo.clsorgprp k = new nsBo.clsorgprp();
                k.p_orgcod = Convert.ToInt32(dr[0]);
                k.p_orgnam = dr[1].ToString();
                k.p_orgdom = dr[2].ToString();
                k.p_orgcrtdat = Convert.ToDateTime(dr[3]);
                obj.Add(k);
            }
            dr.Close();
            cmd.Dispose();
            con.Close();
            return obj;
        }

Now in Presentation layer i want to display name in drop down list and value field = code. How it can be done.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

15y ago
Accepted answer
dropdownlist.DataSource = List;
dropdownlist.DataTextField="Name Filed Name";
dropdownlist.DataValueField="Value Field Name"
dropdownlist.DataBind();

http://www.primaryobjects.com/CMS/Article95.aspx
http://stackoverflow.com/questions/4490087/populate-dropdown-list-from-a-list-of-objects
0