Home > Archive > C# > April 2006 > How to SELECT FROM In-Memory dataset in C# .NET?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to SELECT FROM In-Memory dataset in C# .NET?
|
|
| BillJohnson4@gmail.com 2006-04-28, 8:04 am |
| Experts:
I have built an in-memory dataset by parsing a flat file so that I can
display the contents onto a datagrid.
The Microsoft C# .NET System.Data.DataTable.Select() method allows me
to select all rows that meet certain criteria (just like "WHERE") and
to sort them (just like "ORDER BY").
I want to perform more analysis on this in-memory dataset such as
SUM(), COUNT(*), MIN(), MAX() and possibly even JOIN.
There has to be a way to do SQL commands 100% in-memory without writing
this dataset to a database server. We already have the data in a
dataset in-memory. How can we then use the power of SQL or C# to
process the data further?
Thank you.
| |
| Stoitcho Goutsev \(100\) 2006-04-28, 7:03 pm |
| Bill,
> The Microsoft C# .NET System.Data.DataTable.Select() method allows me
> to select all rows that meet certain criteria (just like "WHERE") and
> to sort them (just like "ORDER BY").
>
> I want to perform more analysis on this in-memory dataset such as
> SUM(), COUNT(*), MIN(), MAX() and possibly even JOIN.
According MSDN all this is supported by the select methods. For more details
see:
http://msdn.microsoft.com/library/d...br />
topic.asp
--
Stoitcho Goutsev (100)
| |
| BillJohnson4@gmail.com 2006-04-28, 7:03 pm |
| Stoicho:
Thank you for the link; however, it still does not answer how I can
SUM() across all rows.
I would like to create a view, a column, whatever to SUM() or AVG() or
MIN() or MAX() across all rows of a table in memory.
Any clues or hints?
|
|
|
|
|