C# button控件遍历并修改text的问题
我要遍历一个界面中的所有button控件,并根据数据库查询确定button的text的值,button的ID为Button1,Button2等一共四个,以下为代码,可以运行但是没有text的改变,请各位大牛不吝赐教。
protected void Page_Load(object sender, EventArgs e)
{
foreach (Control c in this.Controls)
{
if (c.GetType() == typeof(Button))
{
Button c_btn = c as Button;
for (int i = 1; i <= 4; i++)
{
if (c_btn.ID == "Button" + Convert.ToString(i))
{
MySqlConnection conn = new MySqlConnection(ConfigurationManager.AppSettings["dbconnectionstring"]);
conn.Open();
string sql = @"select count(*) from total_table where goods_shelf ='A" + i + "';";
MySqlCommand cmd = new MySqlCommand(sql, conn);
int goods_num = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
c_btn.Text = Convert.ToString(goods_num);
}
}
}
}
}