我想写个用DropDownList来显示数据库中第一列所有的数据，不知道从何下手，哪位大侠帮帮小弟啊！

只要求输出数据库中的第一列！！！

要是没代码 请不要发贴，谢谢！

刚写的航班查询,没写注释,自己看吧.
private void Page_Load(object sender, System.EventArgs e)
{
if(!this.IsPostBack)
{
this.GetFlightCityName();
}
}

void GetFlightCityName()
{
DAL.HB dal = new HBinfo.DAL.HB();
DataTable dt = dal.GetFlightCityNameByFlight();
for(int i=0;i<dt.Rows.Count;i++)
{
this.DropDownList1.Items.Add(dt.Rows[i]["DepartureCityName"].ToString());
}
}
//////////////
public class HB
{
const string SQL_CATE_SELECTFLIGHTCITYNAME = "select DepartureCityName from Flight";

/// <summary>
///
/// </summary>
/// <returns></returns>
public DataTable GetFlightCityNameByFlight()
{
DataTable dt = new DataTable();
SqlHelper.FillDataTable(SQL_CATE_SELECTFLIGHTCITYNAME,dt);
return dt;
}
}
///////////////
public class SqlHelper
{
static public readonly string ConnStr= "server=.;uid=sa;pwd=;database=HBInfo";

/// <summary>
///
/// </summary>
/// <param name="sql"></param>
/// <param name="dt"></param>
static public void FillDataTable(string sql, DataTable dt,params SqlParameter[]parms)
{
using(SqlConnection con = new SqlConnection(ConnStr))
{
SqlDataAdapter ada = new SqlDataAdapter(sql, con);
foreach(SqlParameter p in parms)
ada.SelectCommand.Parameters.Add(p);
ada.Fill(dt);
}
}
}

string sqlstr = "select aaa from table1";
SqlConnectiong myconn = ...............;
SqlDataAdapter da = new SqlDataAdapter(sqlstr,myconn);
DataSet ds = new DataSet();
da.Fill(ds);
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "aaa";
DropDownList1.DataValueField = "aaa";
DropDownList1.DataBind();

谢谢 楼上2位的代码，惜别2日，再次来到论坛，看到有人关心我的帖子，很是感激，
拜谢！