question about query datatable

[Guest]

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

 

[Guest]

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

 

[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'");

 

[Guest]

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

Chris