Implementing Group By in a DataSet in VB.NET

Insert this for avg Case "avg"DestRow(Field.FieldAlias) = Avg(DestRow(Field.FieldAlias), SourceRow(Field.FieldName)) and: Public Function Avg(ByVal a As Object, ByVal b As Object) As Object'Averages two values - if one is DBNull, then returns the other'' if (a is DBNull)' return b;' if (b is DBNull)' return a;' Dim dblA As Double = 0.0Dim dblB As Double = 0.0Double.TryParse(a.ToString(), dblA)Double.TryParse(b.ToString(), dblB)Return ((Convert.ToDouble(dblA) + Convert.ToDouble(dblB)) / 2)End Function

Thank you for great class! But why average (avg) operator is missed?

many thanks

Hi, I am developing one windows application in vb.net which creates digitally signed pdf. I am getting one exception (System.OutOfMemoryexception) after generating some (1200) pdf. I've properly closed all objects and flushed the file stream which i've used in the application. But still i am getting the error. Any Idea?

Hi Mahesh, I got it from InsertGroupByInto. Its working fine. Thank you.

Dear Mahesh, I'd tried to use your DatasetHelper. Called CreateGroupByTable by passing table name, Datatable and field which datatable to be group by but it returns me only datatable with column name which i'd passed for groupby and without data. Please clarify ... Thank you for providing such usefull article.

any other?