备忘:asp.net简单实现服务器控件的动态绑定
- string provincelistsql = "select distinct Province from V_Map where Province is not null;";
- string sConnPars = Utils.Instance.GetConnectionString();
- SqlConnection oConn = new SqlConnection(sConnPars);
- SqlDataAdapter myda = new SqlDataAdapter(provincelistsql, oConn);
- DataSet myds = new DataSet();
- oConn.Open();
- myda.Fill(myds, " V_Map");
- provincelist.DataSource = myds;
- provincelist.DataTextField = "Province";
- provincelist.DataValueField = "Province";
- provincelist.DataBind();
- oConn.Close();