need sum of cash and sum of cheque

yesubabu k

9y1kWindows Forms

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
try like this
DataTable dt = dbFunctions.getTable("pr_getLedgerSheet '" + fromdate.Value.ToString("yyyyMMdd") + "','" + todate.Value.ToString("yyyyMMdd") + "'");
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Visible=false;

dt = dt.Select("SELECT sum(Income) as Income, sum(Expenses) as Expences,
PayMode GROUP BY PayMode order by PayMode );
txttotincomecash.Text=dt.Rows[0][0].ToString();
txttotincomecheck.Text=dt.Rows[1][0].ToString();
txttotExpencecash.Text=dt.Rows[0][1].ToString();
txttotExpencecheck.Text=dt.Rows[1][1].ToString();

+1
Rafnas T P9y ago
you have datatable right for binding data to this grid
then try this
DataTable dt = GetSampleDataTable(); //Get the table above.
dt = dt.Select("SELECT sum(Income) as Income, sum(Expenses) as Expences,
PayMode GROUP BY PayMode order by PayMode );
txttotincomecash.Text=dt.Rows[0][0].ToString();
txttotincomecheck.Text=dt.Rows[1][0].ToString();
txttotExpencecash.Text=dt.Rows[0][1].ToString();
txttotExpencecheck.Text=dt.Rows[1][1].ToString();
+1
yesubabu k9y ago
CREATE proc pr_getLedgerSheet --'20170227','20170301'
@from datetime,
@to datetime
as
begin

select 1 as ID,@from as Date, cast(0 as varchar) as BillNo,''as Customer,'Opening' as Types,isnull(sum(Income),0)-isnull(sum(Expenses),0) as Income,0.00 as Expenses,'Cash' as PayMode from fn_getLedger()
where convert(varchar,date,112)
union all
select ID,Date,BillNo,Customer,Types,Income,Expenses,Paymode from fn_getLedger()
where convert(varchar,date,112)>=convert(varchar,@from,112) and convert(varchar,date,112)<=convert(varchar,@to,112)
order by date

end

this is the procedure
+1
yesubabu k9y ago
DataTable dt = dbFunctions.getTable("pr_getLedgerSheet '" + fromdate.Value.ToString("yyyyMMdd") + "','" + todate.Value.ToString("yyyyMMdd") + "'");
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Visible=false;

this is the code sir
+1
yesubabu k9y ago
sir need to display total cheque amount and total cash amount from gridview
how can i sir?
+1
Rafnas T P9y ago
select sum(Income) as Income, sum(Expenses) as Expences, PayMode from
TableName group by PayMode
+1
Nitin Sontakke9y ago
Is it editable? If yes, I am sure you must having some event to handle and write code in it. Simple.

Share the code, if possible. It is quicker that way.

Also, share maximum information in the beginning itself. Don't assume anything. There is no way for us to imagine your environment at all!
+1
yesubabu k9y ago
Tanque sir

But that is gridview so from that grid how can calculate sum of cash and sum of cheque
then display in seperate labels
please help me i am new to this sir
+1
Nitin Sontakke9y ago
I had posted a reply to your earlier question http://www.c-sharpcorner.com/forums/need-cash-amount-separate-and-cheque-separate to which never respond, which is not good!

Anyway....
select sum(case when PayMode = 'Cash' then Income else 0.00 end) [CashIncome]
  ,sum(case when PayMode = 'Cash' then Expenses else 0.00 end) [CashExpenses]
  ,sum(case when PayMode = 'Cheque' then Income else 0.00 end) [ChequeIncome]
  ,sum(case when PayMode = 'Cheque' then Expenses else 0.00 end) [ChequeExpenses]
from table_name
where 1 = 1 //and your condition here...
+1
Joginder Banger9y ago
try this
create table #Test(income int, Expenses int,paymode varchar(max))
insert into #Test VALUES(1200,45,'cash')
insert into #Test VALUES(0,45,'cheque')
insert into #Test VALUES(0,456,'cash')
insert into #Test VALUES(100,456,'Cheque')


select sum(income) Income,sum(Expenses) Expenses,paymode from #Test group by paymode


Output :


Income Expenses    paymode
1200 501         cash
100         501         Cheque
+1