datarow 怎么改?

Question

新建一个DATATABLE在填充进去,怎么弄?

Answer 1

        DataTable dtl = ds.Tables[0].Clone();
        //删除重复记录
        foreach (DataRow rowN in ds.Tables[0].Rows)
        {
            DataRow[] rows = dtl.Select("姓名='" + rowN["姓名"].ToString() + "'");
            if (rows.Length == 0)
            {
                dtl.Rows.Add(rowN.ItemArray);
            }
            else
            {
                //判断是否满足合并条件
                if(rowN["day"].ToString()=="事")
                    rows[0]["day"] = rowN["day"];
            }
        }