public void BindGrid()
{
string setting=Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
//创建数据库连接
SqlConnection cn=new SqlConnection(setting);
string mysql="select User_name from users";
SqlDataAdapter da = new SqlDataAdapter(mysql, cn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
ArrayList Product_name = new ArrayList();
Product_name.Add("选择经办人");
for (int i=0; i < ds.Tables["users"].Rows.Count - 1; i++)
{
Product_name.Add(ds.Tables["users"].Rows[i]["User_name"]);
}
dd2.DataSource = Product_name;
dd2.DataBind();
}
{
string setting=Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
//创建数据库连接
SqlConnection cn=new SqlConnection(setting);
string mysql="select User_name from users";
SqlDataAdapter da = new SqlDataAdapter(mysql, cn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
ArrayList Product_name = new ArrayList();
Product_name.Add("选择经办人");
for (int i=0; i < ds.Tables["users"].Rows.Count - 1; i++)
{
Product_name.Add(ds.Tables["users"].Rows[i]["User_name"]);
}
dd2.DataSource = Product_name;
dd2.DataBind();
}