dropdownlist数据绑定

在web.config配置文件连接数据库

 <connectionStrings>
  <add name="scon" connectionString="server=.;uid=sa;pwd=sa;database=address;"/>
 </connectionStrings>

 

新建一个 SqlHelp 类

 string scon = System.Configuration.ConfigurationManager.ConnectionStrings["scon"].ConnectionString;
       /// <summary>
       /// 执行查询的方法返回的是一个dataset
       /// </summary>
       /// <param name="strsql">sql语句</param>
       /// <returns></returns>
        public DataSet Reds(string strsql)
        {
          using(SqlConnection conn=new SqlConnection(scon))
          {
              SqlDataAdapter sda = new SqlDataAdapter(strsql,conn);
              DataSet ds = new DataSet();
              sda.Fill(ds);
              return ds;
          }
        }

 

在Page_Load事件中

 string strsql = "select * from province";
                DataSet ds = SqlHelper.gda(strsql);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    ListItem item = new ListItem();

                    item.Text = ds.Tables[0].Rows[i]["proname"].ToString();
                    item.Value = ds.Tables[0].Rows[i]["proid"].ToString();

                    this.DropDownList1.Items.Add(item);
                }