DataTable操作

 //DataTable select 过滤返回新DataTable
        public DataTable DVIDatatable(string KeyWord, string Word, DataTable dt)
        {

            DataRow[] rows = dt.Select("" + KeyWord + " like '%" + Word + "%'");
            DataTable newDataTable = dt.Clone();
            int count = rows.Count();
            if (count == 0)
            {
                return newDataTable;
            }
            else
            {
                rows[0][KeyWord].ToString();

                object[] obj = new object[newDataTable.Columns.Count];
                for (int i = 0; i < rows.Count(); i++)
                {
                    rows[i].ItemArray.CopyTo(obj, 0);
                    newDataTable.Rows.Add(obj);
                }
                return newDataTable;
            }
        }
        //DataTable合并返回新DataTable
        private DataTable UniteDataTable(DataTable DataTable1, DataTable DataTable2)
        {
            DataTable newDataTable = DataTable1.Clone();
            object[] obj = new object[newDataTable.Columns.Count];
            for (int i = 0; i < DataTable1.Rows.Count; i++)
            {
                DataTable1.Rows[i].ItemArray.CopyTo(obj, 0);
                newDataTable.Rows.Add(obj);
            }
            for (int i = 0; i < DataTable2.Rows.Count; i++)
            {
                DataTable2.Rows[i].ItemArray.CopyTo(obj, 0);
                newDataTable.Rows.Add(obj);
            }
            return newDataTable;
        }
        //DataTable搜索列返回新DataTable
        public DataTable SearchTable(string[] columns, string Word, DataTable original)
        {
            int i = columns.Count();
            DataTable[] Search = new DataTable[i];
            for (int j = 0; j <= i - 1; j++)
            {
                Search[j] = DVIDatatable(columns[j], Word, original);
            }
            DataTable ReturnTable = original.Clone();
            for (int k = 0; k < i - 1; k++)
            {

                ReturnTable = UniteDataTable(ReturnTable, Search[k]);
            }
            return ReturnTable;
        }