//cnn = New SqlConnection(strCnn) //cnn.Open() cmd = new SqlCommand("select 员工ID,姓名 from 员工表 order by 姓名", cnn); dread = cmd.ExecuteReader(); while (dread.Read()) { ListItem pItem = new ListItem(dread[1].ToString().Trim(), dread[0].ToString().Trim()); cList.Items.Add(pItem); pItem.Attributes.Add("onclick", "javascript:setchecked(this);"); } cmd.Dispose(); dread.Close(); //显示选择结果
string strSQL=string.Format("select 评委ID from 新评委表 where 考评组别={0} and 评委组别={1}",groupID,regID); cmd = new SqlCommand(strSQL, cnn); dread = cmd.ExecuteReader(); while (dread.Read()) { foreach(ListItem itmPro in cList.Items) { if (itmPro.Value.ToString().Trim() == dread[0].ToString().Trim()) { itmPro.Selected = true; itmPro.Attributes.Add("Style", "background-color:#ff7b7b"); } } } dread.Close(); cmd.Dispose(); //cnn.Close() }
private void TestBind() { DataTable tableAll = db.ExecuteDataset("SELECT roleID,roleName FROM role").Tables[0]; DataTable tableCK = db.ExecuteDataset("SELECT roleID FROM role_group WHERE userID=1").Tables[0]; for (int i = 0; i < tableAll.Rows.Count; i++) { ListItem newItem = new ListItem(tableAll.Rows[i]["roleName"].ToString(), tableAll.Rows[i]["roleID"].ToString()); for (int j = 0; j < tableCK.Rows.Count; j++) { if (newItem.Value == tableCK.Rows[j][0].ToString()) { newItem.Selected = true; break; } } CheckBoxListRole.Items.Add(newItem); } }
for(int i = 0 ; i<GridView1.Rows.Count;i++)
{
GridViewRow dRow = GridView1.Rows[i];
TextBox dText=(TextBox)dRow.FindControl("textBox1");
int regID = Convert.ToInt32(GridView1.DataKeys[dRow.RowIndex].Value.ToString().Trim());// '评委组别
DataRow tempRow = tempDataTable.Rows[i];
dText.Text = tempRow["组权重"].ToString().Trim();
CheckBoxList dCheckList = (CheckBoxList)dRow.FindControl("CheckBoxList1");
bindCheckList(dCheckList, groupID, regID);
}
private void bindCheckList( CheckBoxList cList , int groupID, int regID)
{
cList.Items.Clear();
//cnn = New SqlConnection(strCnn)
//cnn.Open()
cmd = new SqlCommand("select 员工ID,姓名 from 员工表 order by 姓名", cnn);
dread = cmd.ExecuteReader();
while (dread.Read())
{
ListItem pItem = new ListItem(dread[1].ToString().Trim(), dread[0].ToString().Trim());
cList.Items.Add(pItem);
pItem.Attributes.Add("onclick", "javascript:setchecked(this);");
}
cmd.Dispose();
dread.Close();
//显示选择结果
string strSQL=string.Format("select 评委ID from 新评委表 where 考评组别={0} and 评委组别={1}",groupID,regID);
cmd = new SqlCommand(strSQL, cnn);
dread = cmd.ExecuteReader();
while (dread.Read())
{
foreach(ListItem itmPro in cList.Items)
{
if (itmPro.Value.ToString().Trim() == dread[0].ToString().Trim())
{
itmPro.Selected = true;
itmPro.Attributes.Add("Style", "background-color:#ff7b7b");
}
}
} dread.Close();
cmd.Dispose();
//cnn.Close()
}
{
DataTable tableAll = db.ExecuteDataset("SELECT roleID,roleName FROM role").Tables[0];
DataTable tableCK = db.ExecuteDataset("SELECT roleID FROM role_group WHERE userID=1").Tables[0];
for (int i = 0; i < tableAll.Rows.Count; i++)
{
ListItem newItem = new ListItem(tableAll.Rows[i]["roleName"].ToString(), tableAll.Rows[i]["roleID"].ToString());
for (int j = 0; j < tableCK.Rows.Count; j++)
{
if (newItem.Value == tableCK.Rows[j][0].ToString())
{
newItem.Selected = true;
break;
}
}
CheckBoxListRole.Items.Add(newItem);
}
}