Question

I am trying to find a fast way to find a string in all datatable columns! Followed is not working as I want to search within all columns value.

string str = "%whatever%";
foreach (DataRow row in dataTable.Rows)
    foreach (DataColumn col in row.ItemArray)
        if (row[col].ToString() == str) return true;

Answer 1

可以通过过滤来实现这一点。 1. 根据所有栏目建立(可使用)过滤器:

        bool UseContains = false;
        int colCount = MyDataTable.Columns.Count;


        string likeStatement = (UseContains) ? " Like  %{0}% " : " Like  {0}% "; 
        for (int i = 0; i < colCount; i++)
        {
            string colName = MyDataTable.Columns[i].ColumnName;
            query.Append(string.Concat("Convert(", colName, ",  System.String )", likeStatement));


            if (i != colCount - 1)
                query.Append(" OR ");
        }

        filterString = query.ToString();

现在,你可以浏览一下哪一栏与你的搜索相匹配:

 string currFilter = string.Format(filterString, searchText);
 DataRow[] tmpRows = MyDataTable.Select(currFilter, somethingToOrderBy);

Answer 2

你们可以使用LINQ。这样做不会更快,因为如果价值没有,你仍需要看每个囚室,但会符合一条:

return dataTable
    .Rows
    .Cast<DataRow>()
    .Any(r => r.ItemArray.Any(c => c.ToString().Contains("whatever")));

为了寻找随机案文,并归还至少有一个对个案不敏感的囚室的一系列行文:

var text = "whatever";
return dataTable
    .Rows
    .Cast<DataRow>()
    .Where(r => r.ItemArray.Any(
        c => c.ToString().IndexOf(text, StringComparison.OrdinalIgnoreCase) > 0
    )).ToArray();

Answer 3

如果你想检查你每栏一栏每栏一行。数据表,尝试(我的工作!)

DataTable YourTable = new DataTable();
// Fill your DataTable here with whatever you ve got.

foreach (DataRow row in YourTable.Rows)
{
    foreach (object item in row.ItemArray)
    {
        //Do what ya gotta do with that information here!
    }
}

Don tabes to打字object items to what per cent (string, int等)。

我赶上了挖尸首,并做药。我希望这一帮助和好uck!

Answer 4

你们也可以用一系列星号进行例行搜查:

string[] elems = {"GUID", "CODE", "NAME", "DESCRIPTION"};//Names of the columns             
foreach(string column in elems)
{
    string expression = string.Format("{0} like  %{1}% ",column, 
    txtSearch.Text.Trim());//Search Expression
    DataRow[] row = data.Select(expression);
    if(row.Length > 0) {
        // Some code here
    } else {
        // Other code here
    }
 }

Answer 5

你可以通过使用哥伦纳梅方法获得各栏的名称。然后,可以通过使用数据检索每个栏目。例如,环礁法典将发挥作用。

string str = "whatever";
foreach (DataRow row in dataTable.Rows)
{
    foreach (DataColumn column in dataTable.Columns)
    {
        if (row[column.ColumnName.ToString()].ToString().Contains(str))
        {
            return true; 
        }
    }
}

Answer 6

你们也可以在数据表上形成一个过滤的表述。见http://msdn.microsoft.com/en-us/library/zk13kdh0%28v=vs.71%29.aspx“rel=“nofollow”>。就像在你的过滤表达中使用。

 string filterExp = "Status =  Active ";
 string sortExp = "City";
 DataRow[] drarray;
 drarray = dataSet1.Customers.Select(filterExp, sortExp, DataViewRowState.CurrentRows);
 for (int i=0; i < drarray.Length; i++)
 {
    listBox1.Items.Add(drarray[i]["City"].ToString());
 }

友情链接