Sum

[OuTCasT]

i am printing a datagridview into excel sheet.....
now the columns all work out, one column is like Profit column and the other is a Profit % column

Now i cant add a row to the datagridview programmatically because it is databound, i need to sum the profit column in the same sql statement as when im working out everything....

here is how ive done the datagridview....

select Date,ProductID,Description,BuyingPrice,SellingPrice,Profit_R=(sellingprice-buyingprice),Profit=(sellingprice-buyingprice)/(sellingprice/100),Sold=(quantity),Turnover=(quantity*sellingprice),ProfitTotal=(sellingprice-buyingprice)*(quantity) from orders where date = '" & lbldate.Text & "'", sqlCon

all i need now is to sum up the TURNOVER column and add it to the same datagridview so that it can be printed along with the datagridview print.....

[ck9663]

i am printing a datagridview into excel sheet.....
now the columns all work out, one column is like Profit column and the other is a Profit % column

Now i cant add a row to the datagridview programmatically because it is databound, i need to sum the profit column in the same sql statement as when im working out everything....

here is how ive done the datagridview....

select Date,ProductID,Description,BuyingPrice,SellingPrice,Profit_R=(sellingprice-buyingprice),Profit=(sellingprice-buyingprice)/(sellingprice/100),Sold=(quantity),Turnover=(quantity*sellingprice),ProfitTotal=(sellingprice-buyingprice)*(quantity) from orders where date = '" & lbldate.Text & "'", sqlCon

all i need now is to sum up the TURNOVER column and add it to the same datagridview so that it can be printed along with the datagridview print.....

option 1:
handle it on your GUI. during population, you can add each time the row is incremented or if your GUI to add a variable object and simple click "sum" and it's doing the rest...or

option 2:
run another query
select Turnover=(quantity*sellingprice),ProfitTotal=(sell ingprice-buyingprice)*(quantity) from orders where date = '" & lbldate.Text & "'", sqlCo

-- ck

[OuTCasT]

option 1:
handle it on your GUI. during population, you can add each time the row is incremented or if your GUI to add a variable object and simple click "sum" and it's doing the rest...or

option 2:
run another query
select Turnover=(quantity*sellingprice),ProfitTotal=(sell ingprice-buyingprice)*(quantity) from orders where date = '" & lbldate.Text & "'", sqlCo

-- ck

ive used another select statement which loads when the datagridview loads with its data

(select SUM(profit) from orders where date = ' " & lblDate.text " ' ",sqlcon)

but i need to get that into the datagrid
i tried to insert a row manually like this

withme.datagridview1.rows.add("Total Profit")

but it says cannot add rows programmatically to datagridview when datagridview is data bound