need sum of cash and sum of cheque

Question

Rafnas T P · Answer

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();

Rafnas T P · Answer

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();

yesubabu k · Answer

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) order by date end this is the procedure

yesubabu k · Answer

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

yesubabu k · Answer

sir need to display total cheque amount and total cash amount from gridview how can i sir?

Rafnas T P · Answer

select sum (Income) as Income, sum (Expenses) as Expences, PayMode from TableName group by PayMode

Nitin Sontakke · Answer

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!

yesubabu k · Answer

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

Nitin Sontakke · Answer

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...

Joginder Banger · Answer

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