• 删除DataTable中重复的记录


     /// <summary>
            /// 删除DataTable中重复的记录  

          /// </summary>
            /// <param name="ds"></param>
            /// <returns></returns>
            public DataSet DeleteSameData(DataSet ds)
            {
                DataSet resultds = ds.Clone();
                DataSet Tempds=ds;        

                int count = 0;        

                if (ds != null && ds.Tables.Count > 0)
                {
                    count = ds.Tables[0].Rows.Count;

                    for (int i = 0; i < count; i++)
                    {
                        DataRow dri = Tempds.Tables[0].Rows[i];

                        if (dri.RowState == DataRowState.Deleted) continue;

                        resultds .Tables[0].ImportRow(dri);

                        for (int j = i + 1; j < count; j++)
                        {
                            DataRow drj = Tempds.Tables[0].Rows[j];
                            if (drj.RowState == DataRowState.Deleted) continue;
                             if (anwercount <= 1) continue;

                            //判断相同
                            bool flage = false;
                            flage = JudgeSame(dri, drj);
                            if (flage)
                            {
                                //除去相同

                                Tempds.Tables[0].Rows[j].Delete();
                            }
                           

                        }
                    }

                }   


                return resultds ;
            }
          

  • 相关阅读:
    linux中如何修改文件夹的用户权限 chown命令
    httpserver
    协程
    进程和线程的区别和联系
    python线程的GIL问题(全局解释器锁)
    线程同步互斥的方法
    threading模块创建线程
    信号量(信号灯)
    信号通道
    内存共享
  • 原文地址:https://www.cnblogs.com/discoverx/p/2185043.html
Copyright © 2020-2023  润新知