我正在基于数据库中的条目动态创建表。在创建过程中,我将DB字段之一分配给Table.ID
。如何使用来更改表格的背景色FindControl(ID)
?
protected void AgentStat_Tick(object sender, EventArgs e)
{
Dictionary<string, string> activityAgent = new Dictionary<string, string>();
string conString = "Data Source = lewcomp1\\COMPLIANCE; Initial Catalog = 3CXCallStats; Integrated Security = True;";
string query = "SELECT FirstName, LastName, Status FROM Queue_Listing WHERE [ComplianceCC(English)] = 'True'";
SqlConnection myCon = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand(query, myCon);
SqlDataReader myReader;
myCon.Open();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
string name = myReader["FirstName"].ToString();
string surname = myReader["LastName"].ToString();
string status = myReader["Status"].ToString();
activityAgent.Add(name + surname.Substring(0, 1), status);
}
foreach (KeyValuePair<string, string> item in activityAgent)
{
if (item.Value == "Connected")
{
var state = listAgents.FindControl(item.Key);
}
}
}
我创建而不是使用var,而是创建表的实例,并将其指向正确的方向。请看下面:
TableCell tCell = (TableCell)listAgents.FindControl(item.Key);
tCell.BackColor = System.Drawing.Color.Red;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句