This works but.....

[scorpion53061]

select SLSMN, sum(SALESAMT) from yourtable Group By SLSMN

will work when pulling data from a SQL database table. It totals all
salesman's sale amounts and groups it by them.

How could I acomplish this in a datatable where I have already added the
rows but without having to send the rows to the database?

[Armin Zingler]

"scorpion53061" <sc************@yahoo.com> schrieb

select SLSMN, sum(SALESAMT) from yourtable Group By SLSMN

will work when pulling data from a SQL database table. It totals
all salesman's sale amounts and groups it by them.

How could I acomplish this in a datatable where I have already added
the rows but without having to send the rows to the database?

This is not a VB.NET language question, so please turn to
microsoft.public.dotnet.framework.adonet.
--
Armin

[Herfried K. Wagner [MVP]]

"scorpion53061" <sc************@yahoo.com> schrieb:

select SLSMN, sum(SALESAMT) from yourtable
Group By SLSMN

will work when pulling data from a SQL database
table.

This is a VB.NET language group. Please turn to the ADO.NET newsgroup:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups...ups/loadframes
..asp?icp=msdn&slcid=us&newsgroup=microsoft.public .dotnet.framework.adonet>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

[scorpion53061]

You are right of course and I apologize.

"Armin Zingler" <az*******@freenet.de> wrote in message
news:%2***************@TK2MSFTNGP09.phx.gbl...

"scorpion53061" <sc************@yahoo.com> schrieb

select SLSMN, sum(SALESAMT) from yourtable Group By SLSMN

will work when pulling data from a SQL database table. It totals
all salesman's sale amounts and groups it by them.

How could I acomplish this in a datatable where I have already added
the rows but without having to send the rows to the database?

This is not a VB.NET language question, so please turn to
microsoft.public.dotnet.framework.adonet.
--
Armin