Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Jumpstart in linq
Message
General information
Forum:
ASP.NET
Category:
LINQ
Environment versions
Environment:
VB 8.0
OS:
Vista
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01523960
Message ID:
01523968
Views:
54
>>Could somebody translate
>>
>>
>>select Kl_Nummer,ArtBtw,sum(bestd_waarde) as netto from [somtable] group by kl_nummer,ArtBtw
>>
>>
>>into linq?
>>
>>Thanks. Just need to see it done once, or refer me to a link (no pun intended)
>
>Brain not up to that at the moment (if ever :-} ) but you could plough through this :
>http://msdn.microsoft.com/en-us/vcsharp/aa336746

Yeah .... seen that before. Must be crystal clear for anybody with 150 years experience in Linq.

just want to generate a table with the total of one field grouped by another field.

select field1, sum(field2) as total from mytable group by field1.

Should not be rocket science.

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform