• C# DataTable 使用原创


            /// <summary>
            /// 合并DataTable,经保证两个DataTable的结构相同哦
            /// </summary>
            /// <param name="un_duplicated">不重复的列</param>
            public DataTable SumDataTable(DataTable dt1, DataTable dt2, string un_duplicated)
            {
                for (int i = 0; i < dt2.Rows.Count; i++)
                {
                    DataRow dr = dt1.NewRow();
                    for (int j = 0; j < dt2.Columns.Count; j++)
                    {
                        dr[j] = dt2.Rows[i][j];
                    }
                    //判断是否重复
                    bool IsDuplicated = false;
                    for (int k = 0; k < dt1.Rows.Count; k++)
                    {
                        if (dt1.Rows[k][un_duplicated].ToString() == dr[un_duplicated].ToString())
                            IsDuplicated = true;
                    }
                    //没有时重复才合并
                    if (!IsDuplicated)  dt1.Rows.Add(dr);
    
                }
                return dt1;
            }

          //调用

          if ((dt == null)) dt = dt2;
          else dt = SumDataTable(dt, dt2, "name");

            /// <summary>
            /// 筛选DataTable,返回筛选出哪列中,含有该值的DataTable
            /// </summary>
            /// <param name="dt"></param>
            /// <param name="Column">指定第几列</param>
            /// <param name="ColumnValue">该列的值</param>
            /// <returns></returns>
            public DataTable SelectDataTable(DataTable dt, int Column, string ColumnValue)
            {
                try
                {
                    DataTable dtSelectTable = dt.Clone();
                    dtSelectTable.Clear();
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if (dt.Rows[i][Column].ToString() == ColumnValue)
                        {
                            DataRow dr = dtSelectTable.NewRow();
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                dr[j] = dt.Rows[i][j];
                            }
    
                            dtSelectTable.Rows.Add(dr);
                        }
                    }
                    return dtSelectTable;
                }
                catch (Exception)
                {
                    return null;
                }
    
            } 
  • 相关阅读:
    Puppeteer--API
    Puppeteer--性能优化
    Puppeteer--代码示例(3)
    Puppeteer--代码示例(2)
    Puppeteer--代码示例(1)
    Puppeteer--等待加载
    Puppeteer--创建实例
    Puppeteer--爬坑记录
    Puppeteer--参考介绍
    vue.js的的回到顶部
  • 原文地址:https://www.cnblogs.com/cppwen/p/3083677.html
Copyright © 2020-2023  润新知