当前位置: 代码迷 >> ASP.NET >> mysql diopdownlist连接数据库,该怎么解决
  详细解决方案

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

热度:4355   发布时间:2013-02-25 00:00:00.0
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();
}
  相关解决方案