HTML:
<asp:DataList ID="DataList1" runat="server"
onitemcommand="DataList1_ItemCommand" DataKeyField="id">
<HeaderTemplate>
<div style="text-align:center">
<table border = "1" cellpadding="0" cellspacing="0" style=" font-size:12; width:500px" >
<tr>
<td style="width:100px">全选/反选<input id="Checkbox1" type="checkbox" name="全选" value="全选" onclick="return CheckAll(this)" title="全选" /></td>
<td style="width:100px">用户ID</td>
<td style="width:100px">用户名</td>
<td style="width:100px">显示名</td>
<td style="width:100px">操作</td>
</tr>
</table>
</div>
</HeaderTemplate>
<ItemTemplate>
<div style="text-align:center">
<table border = "1" cellpadding="0" cellspacing="0" style=" font-size:12; width:500px" >
<tr>
<td style="width:100px"> <asp:CheckBox ID="CheckBox2" runat="server" /></td>
<td style="width:100px"><asp:Label ID="Label1" runat="server" Text='<%# Eval("UserID") %>'></asp:Label></td>
<td style="width:100px"><asp:Label ID="Label2" runat="server" Text='<%# Eval("UserName") %>'></asp:Label></td>
<td style="width:100px"><asp:Label ID="Label3" runat="server" Text='<%# Eval("DisplayName") %>'></asp:Label></td>
<td style="width:100px"><asp:Button ID="btnDelete" runat="server" Text="删除" CommandName="delete"
BorderStyle="None" onclientclick="return confirm("确认删除？");" /></td><%--请注意此处的CommandName命令--%>
</tr>
</table>
</div>
</ItemTemplate>
<FooterTemplate>
<div style="text-align:center">
<table border="1" cellpadding="0" cellspacing="0" style="font-size:12px; width:100%">
<tr>
<td style="width:100%; text-align:center">
<asp:Button ID="btnPLDelete" runat="server" Text="批量删除" CommandName="pldelete"
BorderStyle="None" onclientclick="return confirm("确认删除？");" /></td>
</tr>
</table>
</div>
</FooterTemplate>
</asp:DataList>
JS:
<script type="text/javascript">
function CheckAll(Obj) {
var AllObj = document.all;
if (Obj.checked)//全选
{
for (var i = 0; i < AllObj.length; i++) {
if (AllObj[i].type == "checkbox") {
AllObj[i].checked = true;
}
}
}
else//反选
{
for (var i = 0; i < AllObj.length; i++) {
if (AllObj[i].type == "checkbox") {
AllObj[i].checked = false;
}
}
}
}
</script>
后台：
DotNetNuke.Entities.Users.UserController ucMgr = new DotNetNuke.Entities.Users.UserController();
public string sqlcon = ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString;
public string type = "0";
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["type"] != null)
type = Request.QueryString["type"].ToString();
if (type == "0")
{
DertDiv.Visible = false;
}
else
{
UserDiv.Visible = false;
}
if (!IsPostBack)
{
//调用自定义方法绑定数据到控件（为以后做MVC打下基础）
BindDataList();
BindDertList();
}
}
private void BindDataList()
{
//定义查询语句,这里最好将SQL语句在SQL中写好并验证正确确在复制粘贴过来（在对数据查询时最好只查所需的一些不需要的数据就不要取出，这样可以提高运行的效率）
SqlConnection scon = new SqlConnection(sqlcon);
string strwhere = " ";
string strSql = "";
if (string.IsNullOrEmpty(tbUserName.Text))
{
strSql = "select * from [Users] where UserID=0";
}
else
{
strwhere += " and Username = '" + tbUserName.Text.Trim() + "' ";
strSql = "select * from [Users] where IsSuperUser=0" + strwhere;//定义一条SQL语句
}
SqlCommand scm = new SqlCommand(strSql, scon);
SqlDataAdapter sqldata = new SqlDataAdapter(scm);
DataSet ds = new DataSet();
sqldata.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
BindDataList();
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
SqlConnection scon = new SqlConnection(sqlcon);
switch (e.CommandName)
{
//单条数据删除操作
case "delete":
//取得当前Datalist控件列
int id = int.Parse(DataList1.DataKeys[e.Item.ItemIndex].ToString());
string strSQL = "delete from Users where UserID='" + id + "'";
if (scon.State.Equals(ConnectionState.Closed))
{
scon.Open();//打开数据库
}
SqlCommand cmd = new SqlCommand(strSQL, scon);
if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0)
{
Response.Write("<script>alert('删除成功！')</script>");
BindDataList();
}
else
{
Response.Write("<script>alert('删除失败！请查找原因')</script>");
}
scon.Close();//关闭连接
break;
////批量数据删除操作
//case "pldelete":
// if (scon.State.Equals(ConnectionState.Closed))
// {
// scon.Open();//打开数据库
// }
// DataListItemCollection dlic = DataList1.Items;//创建一个DataList列表项集合对象
// //执行一个循环删除所选中的信息
// for (int i = 0; i < dlic.Count; i++)
// {
// if (dlic[i].ItemType == ListItemType.AlternatingItem || dlic[i].ItemType == ListItemType.Item)
// {
// CheckBox cbox = (CheckBox)dlic[i].FindControl("CheckBox2");
// if (cbox.Checked)
// {
// int p_id = int.Parse(DataList1.DataKeys[dlic[i].ItemIndex].ToString());
// SqlCommand p_cmd = new SqlCommand("delete from Users where UserID=" + p_id, scon);
// p_cmd.ExecuteNonQuery();
// }
// }
// }
// scon.Close();
// BindDataList();
// break;
}
}
声明：此文系舞林cuzn（www.wulinlw.org）原创稿件，转载请保留版权
