用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字
云代码 - c#代码库

datatable模糊查询

2015-06-17 作者: 莫名其妙举报

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


网友评论    (发表评论)

共1 条评论 1/1页

发表评论:

评论须知:

  • 1、评论每次加2分,每天上限为30;
  • 2、请文明用语,共同创建干净的技术交流环境;
  • 3、若被发现提交非法信息,评论将会被删除,并且给予扣分处理,严重者给予封号处理;
  • 4、请勿发布广告信息或其他无关评论,否则将会删除评论并扣分,严重者给予封号处理。


扫码下载

加载中,请稍后...

输入口令后可复制整站源码

加载中,请稍后...