question about query datatable

[chrisben]

Hi,

I would like to query a datatable in C#. The query is like

select sum(quantity)
from table
where company="IBM"

And I would get this number and display it in my GUI.
Is there a way to do it?
Thanks

Chrisben

[chrisben]

To further clarify my question, the datatable is a datatable object I created
in C#. It is the datasource for my DataGrid. I do NOT need to query sql
server database, instead, I need to do the same thing on the table created in
the C#. thanks

"chrisben" wrote:

Hi,

I would like to query a datatable in C#. The query is like

select sum(quantity)
from table
where company="IBM"

And I would get this number and display it in my GUI.
Is there a way to do it?
Thanks

Chrisben

[Robbe Morris [C# MVP]]

You use the DataTable.Select method or DataTable.Compute method
to perform queries against a DataTable.

Decimal val = dt.Compute("Sum(quantity)","company='IBM'");

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

"chrisben" <ch******@discussions.microsoft.com> wrote in message
news:75**********************************@microsof t.com...

Hi,

I would like to query a datatable in C#. The query is like

select sum(quantity)
from table
where company="IBM"

And I would get this number and display it in my GUI.
Is there a way to do it?
Thanks

Chrisben

[chrisben]

this is exactly what I am looking for. Thanks a lot

Chris

"Robbe Morris [C# MVP]" wrote:

You use the DataTable.Select method or DataTable.Compute method
to perform queries against a DataTable.

Decimal val = dt.Compute("Sum(quantity)","company='IBM'");

--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx

"chrisben" <ch******@discussions.microsoft.com> wrote in message
news:75**********************************@microsof t.com...

Hi,

I would like to query a datatable in C#. The query is like

select sum(quantity)
from table
where company="IBM"

And I would get this number and display it in my GUI.
Is there a way to do it?
Thanks

Chrisben