DataTable.Select("Date > #1/1/00#")

DataRow[] priceDetailCheckRow = priceDetailCheckExistTable.Select("effective_from = #" + effectiveFromDate.ToString(DateFormat) + "#");     


来自于MSDN
http://msdn2.microsoft.com/en-us/library/det4aw50.aspx
private void GetRowsByFilter()
{
    DataTable table 
= DataSet1.Tables["Orders"];
    
// Presuming the DataTable has a column named Date.
    string expression;
    expression 
= "Date > #1/1/00#";
    DataRow[] foundRows;

    
// Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression);

    
// Print column 0 of each returned row.
    for(int i = 0; i < foundRows.Length; i ++)
    
{
        Console.WriteLine(foundRows[i][
0]);
    }

}

posted on 2007-04-19 15:45  Sammy  阅读(1047)  评论(0编辑  收藏  举报

导航