-
ASP.Net 删除xml文件中的数据(delete操作)
XML文件请见ASP.Net中实现XMl的标识列(ID列)或自增长列代码如下:
删除按钮事件:
private void Btn_Delete_Click(object sender, System.EventArgs e)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
string uid = Session["uid"]//取得主键;
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
string [] values =
{uid};
OperateXmlByDataSet.DeleteXmlRows(ViewState["filename"].ToString(),"userid",values); }
OperateXmlByDataSet的DeleteXmlRow方法:
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
DeleteXmlRows#region DeleteXmlRows
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
/// 删除strColumn列中值为ColumnValue的行
/// </summary>
/// <param name="strXmlPath">xml相对路径</param>
/// <param name="strColumn">列名</param>
/// <param name="ColumnValue">strColumn列中值为ColumnValue的行均会被删除</param>
/// <returns></returns>
public static bool DeleteXmlRows(string strXmlPath,string strColumn,string[] ColumnValue)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
try
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DataSet ds = new DataSet();
ds.ReadXml(GetXmlFullPath(strXmlPath));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//先判断行数
if(ds.Tables[0].Rows.Count > 0)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
//判断行多还是删除的值多,多的for循环放在里面
if(ColumnValue.Length > ds.Tables[0].Rows.Count)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
for(int i=0; i < ds.Tables[0].Rows.Count; i++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
for(int j=0; j < ColumnValue.Length; j++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if(ds.Tables[0].Rows[i][strColumn].ToString().Trim().Equals(ColumnValue[j]))
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ds.Tables[0].Rows[i].Delete();
}
}
}
}
else
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
for(int j=0; j < ColumnValue.Length; j++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
for(int i=0; i < ds.Tables[0].Rows.Count; i++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if(ds.Tables[0].Rows[i][strColumn].ToString().Trim().Equals(ColumnValue[j]))
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ds.Tables[0].Rows[i].Delete();
}
}
}
}
ds.WriteXml(GetXmlFullPath(strXmlPath));
}
return true;
}
catch(Exception e)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string ex = e.Message;
return false;
}
}
#endregion
-
相关阅读:
ssh远程执行命令
华为交换机配置命令总结
dmidecode查看设备硬件信息
tcpdump高级过滤技巧
ifconfig 下面的一些字段(errors, dropped, overruns)
awk 高级技巧
intel82599在centos6.5下编译安装
非默认安装目录下mysql数据的导出与导入
bash中使用mysql中的update命令
mysql查看修改字符集
-
原文地址:https://www.cnblogs.com/tenghoo/p/526024.html
Copyright © 2020-2023
润新知