How to query a in memory data base?

I have a in memory data base created by using the disconnected class. I have populated the data table, now I want to query to select particular rows from the data table. What is the most simple way?

Answers


If you use C# and DataTable you can query it for example like:

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

Example from: http://msdn.microsoft.com/en-GB/library/det4aw50.aspx

You can also use LINQ to query the collection by DataTable.AsEnumarable


Need Your Help

Stopping UISearchDisplayController to dismiss the searchbar keyboard

iphone objective-c cocoa-touch uisearchbar uisearchdisplaycontroller

I have a UISearchBar which I am putting in UISearchDisplayController. Now, whenever I tap on the 'Search' button on the keyboard, it dismisses the keyboard. I am implementing the below method to stop

Waiting of selenium webdriver until loading completed

java selenium automation selenium-webdriver testng

I am using selenium webdriver along with TestNG in eclipse.The problem is the page relaods in the midway for some data and the time of this reload is flexible thats why I am not able apply explicit...