急!!!!!在DropDownList中怎么显示一个数据表中的一个字段的内容?

Question

<asp:DropDownList id="ddl" runat="server"/>
void Page_load(object sender,System.EventArgs e)
{
  if (!(IsPostBack))
    {
      String strConn,strSQL;
      strConn=.........;
      strSQL="select youColumn,ID from youtable;";
      SqlConnection objConn=new SqlConnection(strConn);
      SqlCommand objComm=new SqlCommand(strSQL,objConn);
      objConn.Open();
      ddl.DataSource=objComm.ExecuteReader();
      ddl.DataTextField="youColumn";
      ddl.DataValueField="id";
      Page.DataBind();
      objConn.Close();
      
     }}
ddl.DataTextField

Answer 1

string str="select name from table";
...
conn.Open();
SqlCommand cmd=new SqlCommand(str,conn);
SqlDataReader dr=cmd.ExecutReader();
if(dr.Read())
{
DropDownList1.Items.Add(new ListItem(dr.["name"].ToString()));
}