private void fillGridViewExpense(SqlInt32 UserID) { ExpenseDAL dalExpense = new ExpenseDAL(); DataTable dtExpense = new DataTable(); dtExpense = dalExpense.SelectAll(UserID); if (dtExpense != null && dtExpense.Rows.Count > 0) { gvExpense.DataSource = dtExpense; gvExpense.DataBind(); calculateSum(); } else { gvExpense.DataSource = null; gvExpense.DataBind(); } }
public DataTable SelectAll(SqlInt32 UserID) { ExpenseDAL dalExpense = new ExpenseDAL(); return(dalExpense.SelectAll(UserID)); }