How do I show this query in a datagridview properly.

[Guest]

I have a query which has the following phrase
SELECT ... SUM(column1) AS total1...
FROM....
GROUP BY column2.... WITH ROLLUP

Now when I connect a dgview to this datasource I would like the row with the
sum of column1 (ie total1) to be quite distinguishable from the rest in the
dgview, how could I do this?

 

[Chan Ming Man]

Add a new datarow after binding to the datasource and put the value to the
column that you want.

chanmm