dropdownlist下拉框加--请选择---

最新推荐文章于 2024-09-08 13:32:33 发布

weixin_33918114

最新推荐文章于 2024-09-08 13:32:33 发布

阅读量125

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/skyboy110/p/7263411.html

版权

public static DataSet ReturnDataSet(string SqlStr, string tablename)
{
SqlConnection con = new SqlConnection(GetConStr());
con.Open();//打开数据库连接
SqlDataAdapter ada = new SqlDataAdapter(SqlStr, con);
DataSet ds = new DataSet();
ada.Fill(ds, tablename);
return ds;
}

//SqlConnection con = new SqlConnection(Class1.lianjie());
//con.Open();
string cmdCityText = "SELECT * FROM [area] order by proid desc";
DataSet ds = new DataSet();

ds= MyClass.ReturnDataSet(cmdCityText,"aa");
//SqlCommand cmd = new SqlCommand(cmdCityText, con);
// SqlDataReader sdr = cmd.ExecuteReader();
//this.area.DataSource = sdr;

//this.area.DataTextField = "proname";//文本内容
//this.area.DataValueField = "proid"; //数据源字段
//this.area.DataBind();
//ListItem list = new ListItem("--请选择区域--", "-1 ");
//list.Selected = true;
//area.Items.Add(list);
area.Items.Clear();
ListItem item = new ListItem("-请选择区域-");
area.Items.Add(item);
foreach (DataRow dr in ds.Tables[0].Rows)
{
item = new ListItem();
item.Text = dr["proname"].ToString();
item.Value = dr["proid"].ToString();
area.Items.Add(item);
}

转载于:https://www.cnblogs.com/skyboy110/p/7263411.html