How to use Count,Calculate sum(), Caluculate Max() in VB.NET? 2

[Mahey]

Hi
Thanks in Advace.

In VFP9 we can use the followings and How to do it with vb.net?

COUNT FOR(wk_code='Inj ') TO abcd5
CALCULATE SUM(total_hr) FOR (emp_id=epidi1) TO tot1
CALCULATE MAX(en_date) FOR((emp_id=epidi1) TO etydt

--------------------------------------------
In Vb.Net

Dim dbnd1 As New BindingSource
dbnd1.DataSource = DTB4 'Datatable for SEC-ID's


Thanking By
Mahey

 

[RiverGuy]

There's a newer library in .Net to do some of this stuff called LINQ (Language Integrated Query). I haven't yet used it myself, but you can get some information for it here:

http://msdn.microsoft.com/en-us/library/bb397910.aspx

Previously, you would perform these types of calculations as you would with most 3GL languages--lots of loops.

 

[ZmrAbdulla]

Why not scalar queries?
Search for ExecuteScalar

Zameer Abdulla

 

[RiverGuy]

That's fine if you can go back to the database to execute another query, but if the data is already contained in some sort of collection, it's not always an option. But yes I agree, if you are working with a database, try to have the database engine do the lifting for you.

 

[Mahey]

Thanks To Abudulla & River