如何绑定DropDownList?
来源:百度知道 编辑:UC知道 时间:2024/05/16 12:03:30
如何设定数据源?
给你一个在数据库表中选取所有地区的方法
DataSet ds = new DataSet();
ds = myCityCountry.selectCityCountry();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ddlCity.Items.Add(ds.Tables[0].Rows[i]["Big5City"].ToString());
}
ds.Dispose();
public DataSet selectCityCountry()
{
DataSet myds = new DataSet();
try
{
myds = myIDBLayer.ExecDataSet(CommandType.StoredProcedure, "P_DBM_Ret_CityCountry", null);
}
catch (Exception ErrMsg)
{
Logger.Error("[Error]" + DateTime.Now.ToString() + ": " + ErrMsg.ToString());
}
return myds;
}
存储过程为:
select City from tableName
DropDownList.DataSource = 数据源;
DropDownLi