private void ViewHistButton_Click(object sender, EventArgs e)
{
DataTable dt1 = controllerObj.ViewPatientHistory((int)_pid, (string)TypeComboBox.SelectedValue);
HistoryDataGridView.DataSource = dt1;
HistoryDataGridView.Refresh();
}
private void GetHistory()
{
string SQL = "SELECT BeforeBalance as [Before], [Transfer], Amount, NewBalance as New, CONVERT(date, ExecutionTime) as [Date], Memo, CASE Cash WHEN 1 THEN 'Y' ELSE 'N' END AS Cash FROM SavingsEventLog ORDER BY ExecutionTime DESC";
cmd = new SqlCommand(SQL, con);
con.Open();
DataTable table = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(table);
HistoryDataGridView.DataSource = table;
HistoryDataGridView.AutoResizeColumns();
con.Close();
}