datatable模糊查询

[c#]代码库

    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;
        }
    }
    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;
    }
    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;
    }