DataList中添加删除功能
用GridView或者FormView时,如果删除语句是:Delete from tTable where id=@id,然后设置了CommandName="Delete"和DataKeyName="id"以后,如果点击删除按钮就会自动传入DataKeyName参数,也就是把id值传入,就可以直接删除。但是DataList却不行,我们需要这么做才可以达到删除功能:
在DataList的ItemCommand事件中:
protected void dataLst_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string sID = dataLst.DataKeys[e.Item.ItemIndex].ToString();//获取id
string sSql = "delete from PingLun where id=" + sID;
DB.ExecuteNonQuery(sSql);
dataLst.DataBind();
}
}
在DataList的ItemCommand事件中:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)