注册 登录
编程论坛 ASP.NET技术论坛

[求助]下拉菜单显示数据库的每一条数据?何解

小恶魔 发布于 2007-03-09 20:59, 782 次点击
我想写个用DropDownList来显示数据库中第一列所有的数据,不知道从何下手,哪位大侠帮帮小弟啊!

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

要是没代码 请不要发贴,谢谢!
3 回复
#2
球球2007-03-10 01:06

刚写的航班查询,没写注释,自己看吧.
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);
}
}
}

#3
bygg2007-03-10 17:26
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();
#4
小恶魔2007-03-13 18:03
谢谢 楼上2位的代码,惜别2日,再次来到论坛,看到有人关心我的帖子,很是感激,
拜谢!
1