日期:2014-05-18  浏览次数:20449 次

dropDownList绑定数据问题
我想在此控件上加一个 "---请选择--- "
我的绑定代码是这样写的:
SqlConnection   con   =   new   SqlConnection( "server=.;database=jqwdb;uid=sa ");
                string   sql   =   "select   *   from   goodsType ";
                SqlDataAdapter   da   =   new   SqlDataAdapter(sql,   con);
                DataSet   ds   =   new   DataSet();
                da.Fill(ds);
                this.DropDownList1.DataSource   =   ds.Tables[0].DefaultView;
                this.DropDownList1.DataTextField   =   "goodsType ";
                this.DropDownList1.DataValueField   =   "goodsId ";
                this.DropDownList1.DataBind();

------解决方案--------------------
this.DropDownList1.DataBind();
加上一行

this.DropDownList1.Items.Insert(0, new ListItem( "---请选择--- ", "top "));
------解决方案--------------------
同上
------解决方案--------------------
加上
this.DropDownList1.Items.add(new ListItem( "---请选择--- ", "0 "));
this.DropDownList1.SelectedIndex=this.DropDownList1.Items.Count-1;

------解决方案--------------------
lv = new ListItem();
lv.Text = "---请选择--- ";
lv.Value = "0 ";
DropDownList1.Items.Add(lv);
if (DropDownList1.Items.Count > 0)
{
DropDownList1or.SelectedIndex = 0;
}
------解决方案--------------------
SqlConnection con = new SqlConnection( "server=.;database=jqwdb;uid=sa ");
string sql = "select * from goodsType ";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
this.DropDownList1.DataSource = ds.Tables[0].DefaultView;
this.DropDownList1.DataTextField = "goodsType ";
this.DropDownList1.DataValueField = "goodsId ";
this.DropDownList1.DataBind();
this.DropDownList1.Items.Insert(0, new ListItem( "---请选择--- ", "-1 "));
------解决方案--------------------
啊哦
------解决方案--------------------
DropDownList1.Items.Insert(0, new ListItem( "---请选择--- ", "-1 "));
------解决方案--------------------
DropDownList1.Items.Insert(0, new ListItem( "---请选择--- ", "-1 "));
------解决方案--------------------
如果是VS2005,直接点智能标记,编辑项
------解决方案--------------------
vs2005智能标记,编辑项 AppendDataBoundItems= "True "
------解决方案--------------------
DropDownList1.Items.Insert(0, new ListItem( "---请选择--- ", "-1 "));
加“-1”是什么意思?
----------------
指定这一项的Value,根据实际情况,此值不要与其它绑定项的Value值相同