private void btn_Show_Click(object sender, EventArgs e) { int i; dgv_Expense.Rows.Clear(); dgv_Income.Rows.Clear(); Tuple <DataTable, DataTable, DataTable> ProfitLoss = _common.ProfitLoss(dtp_from.Value.ToString("dd/MM/yyyy"), dtp_to.Value.ToString("dd/MM/yyyy")); DataTable income = ProfitLoss.Item1; DataTable ExpensesPay = ProfitLoss.Item2; DataTable expenses = ProfitLoss.Item3; dgv_Expense.Rows.Add("Supplier Payment"); for (i = 1; i < ExpensesPay.Rows.Count; i++) { dgv_Expense.Rows.Add(); dgv_Expense.Rows[i].Cells["Date"].Value = ExpensesPay.Rows[i]["Date"].ToString(); dgv_Expense.Rows[i].Cells["Expence_Name"].Value = ExpensesPay.Rows[i]["Type"].ToString(); dgv_Expense.Rows[i].Cells["Amount"].Value = ExpensesPay.Rows[i]["Amt"].ToString(); } dgv_Expense.Rows.Add(); dgv_Expense.Rows.Add("Other Expenses"); int X = 0; for (int j = i + 2; j < expenses.Rows.Count + ExpensesPay.Rows.Count + 2; j++) { dgv_Expense.Rows.Add(); dgv_Expense.Rows[j].Cells["Date"].Value = expenses.Rows[X]["Date"].ToString(); dgv_Expense.Rows[j].Cells["Expence_Name"].Value = expenses.Rows[X]["Expense"].ToString(); dgv_Expense.Rows[j].Cells["Amount"].Value = expenses.Rows[X]["Amount"].ToString(); X = X + 1; } dgv_Expense.Rows.Add("", "Total", _common.sumGridViewColumn(dgv_Expense, "Amount")); for (i = 0; i < income.Rows.Count; i++) { dgv_Income.Rows.Add(); dgv_Income.Rows[i].Cells["Date_Income"].Value = income.Rows[i]["Date"].ToString(); dgv_Income.Rows[i].Cells["Income_Type"].Value = income.Rows[i]["Type"].ToString(); dgv_Income.Rows[i].Cells["Amount_Income"].Value = income.Rows[i]["Amt"].ToString(); } dgv_Income.Rows.Add("", "Total", _common.sumGridViewColumn(dgv_Income, "Amount_Income")); }