首先我想把数据中的某一值赋值给dropdown显示在页面上,然后可以选择下拉框的选项
解决方案 »
- ASP.NET 取值 在线等啊 (select 经过javascript修改之后 服务端不能正常取值)
- 如何取 PlaceHolder内生成的筛选框的值
- asp.net的发布问题
- 解释正则表达式
- 关于asp.net的前景希望大家讨论下
- 求助:设定了table的<td>宽度,但是还是不能让它换行,为什么?
- dropdownlist怎么样设置部分可选,另一部分不可选??
- 一个表格有5行 每行一个textbox 怎么获取这个textbox的值(非 textboxID.Text 方法!)
- 新手问个关于数据显示的问题20分!
- 怎么链接到子目录中去?比如当前是http://192.168.0.11/aaa,然后转到http://192.168.0.11/aaa/bbb
- 怎样判断给出的时间是不是在当天之内
- 将论坛中帖子中出现的多图片存入数据库的问题(不是相对路径)
dropdown.DataSource = datatable;
dropdown.Text = "name";
dropdown.Value = "id";
dropdown.DataBind();
dropdownlist.selectedvalue=你数据库里面那个值
{
if (!IsPostBack)
{
Database db = DatabaseFactory.CreateDatabase();
string idstr = Page.Request.QueryString["POIINFO_ID"];
ddl(ddlType, "select code,text from s_syscode where parentcode='POITYPE'", "text", "code");
ddl(ddlProvince, "select code ,text from s_syscode where parentcode='AREA'", "text", "code");
string sql = "select * from poiinfo where poiinfo_id='" + idstr + "'";
using (IDataReader reader = db.ExecuteReader(CommandType.Text, sql))
{
while (reader.Read())
{
TxtName.Text = reader["name"].ToString();
ddlType.SelectedValue = reader["type"].ToString();
ddlSubType.SelectedValue = reader["subtype"].ToString();
ddlProvince.SelectedValue = reader["province"].ToString();
ddlCity.SelectedValue = reader["city"].ToString();
ddlCounty.SelectedValue = reader["county"].ToString();
ddlVillage.SelectedValue = reader["village"].ToString();
TxtStreet.Text = reader["street"].ToString();
TxtDoorNum.Text = reader["doornum"].ToString();
TxtPostCode.Text = reader["postcode"].ToString();
TxtB.Text = reader["b"].ToString();
TxtL.Text = reader["l"].ToString();
TxtAddress.Text = reader["address"].ToString();
TxtTel.Text = reader["tel"].ToString();
FCKeditor1.Value = reader["content"].ToString();//读取blob未写
TxtMemo.Text = reader["memo"].ToString();
}
}
}
}
public void ddl(DropDownList DDL, string sqlstr, string dtf, string dvf)
{
Database db = DatabaseFactory.CreateDatabase();
DataSet ds = db.ExecuteDataSet(CommandType.Text, sqlstr);
DDL.DataSource = ds;
DDL.DataTextField = dtf;
DDL.DataValueField = dvf;
DDL.DataBind();
}
这是我写的,但是赋值不对
{
Database db = DatabaseFactory.CreateDatabase();
DataSet ds = db.ExecuteDataSet(CommandType.Text, sqlstr);
DDL.DataSource = ds;
DDL.DataTextField = dtf;
DDL.DataValueField = dvf;
DDL.DataBind();
DDL.SelectedIndex=1;
}
ddlType.SelectedValue = reader["type"].ToString();
为什么就是不是数据库中的那个值呢
或者说有的时候一般都是这个值是"test "中间多个空格而已,还是没有赋值给它选中的项。
DDL.DataTextField = dtf;
DDL.DataValueField = dvf; 如果这里的ds有值的话,dtf,dvf确实是两个字段的话。
那么你改下
DDL.DataSource = ds.Tables[0];试试。。如果连单步都不会,建议你问下你旁边的人。
我问的是在dropdownlist中显示的问题,看看我上面写的代码,看看什么地方写错了
还是那句话,调试下,或许赋值时,应该是赋值"test",被你的reader读出来的是"test "
{
if (!IsPostBack)
{
Database db = DatabaseFactory.CreateDatabase();
string idstr = Page.Request.QueryString["POIINFO_ID"];
ddl(ddlType, "select code,text from s_syscode where parentcode='POITYPE'", "text", "code");
ddl(ddlProvince, "select code ,text from s_syscode where parentcode='AREA'", "text", "code");
string sql = "select * from poiinfo where poiinfo_id='" + idstr + "'";
using (IDataReader reader = db.ExecuteReader(CommandType.Text, sql))
{
while (reader.Read())
{
TxtName.Text = reader["name"].ToString();
ddlType.SelectedValue = reader["type"].ToString();
ddlSubType.SelectedValue = reader["subtype"].ToString();
ddlProvince.SelectedValue = reader["province"].ToString();
ddlCity.SelectedValue = reader["city"].ToString();
ddlCounty.SelectedValue = reader["county"].ToString();
ddlVillage.SelectedValue = reader["village"].ToString();
TxtStreet.Text = reader["street"].ToString();
TxtDoorNum.Text = reader["doornum"].ToString();
TxtPostCode.Text = reader["postcode"].ToString();
TxtB.Text = reader["b"].ToString();
TxtL.Text = reader["l"].ToString();
TxtAddress.Text = reader["address"].ToString();
TxtTel.Text = reader["tel"].ToString();
FCKeditor1.Value = reader["content"].ToString();//读取blob未写
TxtMemo.Text = reader["memo"].ToString();
}
}
}
}
public void ddl(DropDownList DDL, string sqlstr, string dtf, string dvf)
{
Database db = DatabaseFactory.CreateDatabase();
DataSet ds = db.ExecuteDataSet(CommandType.Text, sqlstr);
DDL.DataSource = ds;
DDL.DataTextField = dtf;
DDL.DataValueField = dvf;
DDL.DataBind();
DDL.SelectedIndex = 1;
} protected void ddlType_OnSelectedIndexChanged(object sender, EventArgs e)
{
ddl(ddlSubType, "select code ,text from s_syscode where parentcode='" + ddlType.SelectedValue + "'", "text", "code");
} protected void ddlProvince_OnSelectedIndexChanged(object sender, EventArgs e)
{
ddl(ddlCity, "select code,text from s_syscode where parentcode='" + ddlProvince.SelectedValue + "'", "text", "code");
} protected void ddlCity_OnSelectedIndexChanged(object sender, EventArgs e)
{
ddl(ddlCounty, "select code,text from s_syscode where parentcode='" + ddlCity.SelectedValue + "'", "text", "code");
} protected void ddlCity_OnDataBound(object sender, EventArgs e)
{
ddl(ddlCounty, "select code,text from s_syscode where parentcode='" + ddlProvince.SelectedValue + "'", "text", "code");
} protected void ddlCounty_OnSelectedIndexChanged(object sender, EventArgs e)
{
ddl(ddlVillage, "select code,text from s_syscode where parentcode='" + ddlCounty.SelectedValue + "'", "text", "code");
} protected void ddlCounty_OnDataBound(object sender, EventArgs e)
{
ddl(ddlVillage, "select code,text from s_syscode where parentcode='" + ddlCity.SelectedValue + "'", "text", "code");
}
我把我写的都给你们看一下吧,看看错误都出在哪儿啊
{1}显示数据
(2)让那个要显示的数据选中。比如
foreach(ListItem item in ddlType.Items)
{
if(item.text="......")
{
item.selected=true;
}
}