SQL Sum() function in vb

[adnanahmed714]

i am trying SQL Sum() function in vb to get sum of one database column but not getting result.

select Sum(columnname) from emp.

help me i want sum value to display in textbox.

also i connected the database right all other quries running fine .except these function SUM ,MIN,MAX etc.

help mehelp mehelp mehelp mehelp mehelp mePLZZZZZZZZZZZ ZZZ

[Hemant Pathak]

Hi............. ..............

it is so simple just u store this value in Recordset

dim cnn as new adodb.connectio n
din rec as new adodb.recordset
'set ur connection string

set rec=cnn.excute( "Select SUM(Columnname) as NewName from TableName")

txtname.text=re c.fields!NewNam e

[adnanahmed714]

Thanks Hemant
i try it and try to get result,hope i will do it.

[GROG]

Thanks Hemant u lighten me up...