嘿,我有获取与数据库填充的CheckBoxList的。 当我做出任何状态更改一个复选框(选中或取消),它不会回来当我提交表单。
以最简单的形式,我有:
<asp:CheckBoxList runat="server" ID="listEmployes" RepeatDirection="Horizontal">
</asp:CheckBoxList>
C#:
protected void btnSubmit_Click(object sender, EventArgs e)
{
_connection.Open();
var employes = listEmployes.Items;
foreach (ListItem employe in employes)
{
if (employe.Selected)
{
_command = new MySqlCommand(String.Format("INSERT IGNORE INTO Liste_Employes (Projet_ID, User_ID) VALUES ({0}, {1})", _projetId, employe.Value), _connection);
}
else
{
_command = new MySqlCommand(String.Format("DELETE IGNORE FROM Liste_Employes WHERE Projet_ID = {0} AND User_ID = {1}", _projetId, employe.Value), _connection);
}
_command.ExecuteNonQuery();
}
}
我缺少的东西吗? 谢谢。