Question Summary in infragistcs footer?

[HelpMe]

Greetings

I need to add Summary to a infragistcs datagrid footer to a column displaying Time in 'hh:mm:ss' format, also the sum should be of only particular roes and not of all the rows.

Eagerly waiting for reply

 

[alim]

We can get time

  MsgBox(Now.ToShortTimeString)'returns only current hour:min
  MsgBox(CStr(TimeOfDay))'returns only current hour:min:sec PM/AM
  MsgBox(DateAndTime.TimeOfDay.ToString)'returns only current Date hour:min:sec PM/AM

If u want to format times from this you can use format command

Dim T as Object
T= format(DateAndTime.TimeOfDay ,"hh:mm:ss tt")
'tt is for PM/AM
'you will have the time format that you like

n the other thing if u want to get summary with some particular rows..

you can use DataSet.DataTable.Compute(expression,Filter) 'command
e.g.

        Me.DataSet1.Customer.Compute("Sum(CustomerId)", "customerid>=1 and customerid<=500")

please goto msdn for more details