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 Typesisnull(sum(Income)0)-isnull(sum(Expenses)0) as Income0.00 as Expenses'Cash' as PayMode from fn_getLedger() where convert(varchardate112) union all select IDDateBillNoCustomerTypesIncomeExpensesPaymode from fn_getLedger() where convert(varchardate112)>=convert(varchar@from112) and convert(varchardate112) 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 (120045 'cash' ) insert into #Test VALUES (045 'cheque' ) insert into #Test VALUES (0456 'cash' ) insert into #Test VALUES (100456 'Cheque' ) select sum (income) Income sum (Expenses) Expensespaymode from #Test group by paymode Output : Income Expenses paymode 1200 501 cash 100 501 Cheque