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; |
} |
by: 发表于:2018-01-03 10:44:00 顶(0) | 踩(0) 回复
??
回复评论