DataSet删除Row

思路：在select语句中加个自定义列，然后在for循环select结果集时给自定义列赋值，最后用foreach再遍历结果集时，删除自定义列的值为所赋的值；

如：在ds里删除没有新闻的新闻种类

 

代码
DataSet dskind = new BLL.WorkFlowTable().GetList("select  0 as co,* from m_news_kind where enable='1' order by taxis");
DataSet dsnews = new DataSet();
if (dskind .Tables[0].Rows.Count > 0)
{
    for (int i = 0; i < dskind .Tables[0].Rows.Count; i++)
    {
          string news_kind = dskind .Tables[0].Rows[i]["news_kind"].ToString();
          dsnews = new BLL.news().GetList("news_kind='" + news_kind + "'");
          if (dsnews.Tables[0].Rows.Count < 1)
          {
                dskind.Tables[0].Rows[i]["co"] = 1;
          }
     }
     foreach (DataRow dr in dskind.Tables[0].Select("co=1"))
     {
            dr.Delete();
     }
}