Can you add a row of data programatically and aggregate it within the radgrid. If so, how?
Example:
I have a grid with 2 columns. One of these columns is a template that runs a function and delivers an output. Within that function I need to manually add data that is not present in the sqldatasource to the grid and use it when performing aggregate functions.
ColumnA - ColumnB
1 - MyFunction(1) - adds new row (1, B)and returns A to column B.
2 - MyFunction(2) - May return just A
Grid should look like
1 - A
1 - B
2 - A
Count 3
Even though SQLDataSource only returns
1 - AB
2 - A
Of course the function is more complex than the example above and I only need details on adding the row of data to the grid so that it can be aggregated. Thanks
Example:
I have a grid with 2 columns. One of these columns is a template that runs a function and delivers an output. Within that function I need to manually add data that is not present in the sqldatasource to the grid and use it when performing aggregate functions.
ColumnA - ColumnB
1 - MyFunction(1) - adds new row (1, B)and returns A to column B.
2 - MyFunction(2) - May return just A
Grid should look like
1 - A
1 - B
2 - A
Count 3
Even though SQLDataSource only returns
1 - AB
2 - A
Of course the function is more complex than the example above and I only need details on adding the row of data to the grid so that it can be aggregated. Thanks