首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

mysql diopdownlist连接数据库,该怎么解决

2012-09-14 
mysql diopdownlist连接数据库#region DropDownList 绑定protected void DropDownListBind(){string sql

mysql diopdownlist连接数据库
#region DropDownList 绑定
  protected void DropDownListBind()
  {
  string sql = "select *from tb_application";
  Common comn = new Common();
  DataSet ds = comn.GetDataSet(sql);

  ddlChapChoice.DataSource = ds.Tables[0].DefaultView;
  ddlChapChoice.DataTextField = "course";
  ddlChapChoice.DataValueField = "qid";
  ddlChapChoice.DataBound();
  }
  #endregion

表是tb_application 要的字段是course 我这样写错的 该怎么写呢? 主键是qid

[解决办法]
protected void DropDownListBind()
{
string sql = "select *from tb_application";//空一格 select * from tb_application
Common comn = new Common();
DataSet ds = comn.GetDataSet(sql);

ddlChapChoice.DataSource = ds.Tables[0].DefaultView;
ddlChapChoice.DataTextField = "course";
ddlChapChoice.DataValueField = "qid";
ddlChapChoice.DataBound();
}

热点排行