public void load_data()
{
dbhand = new DBHandling(filepath);
ds = new DataSet();
ds2 = new DataSet();
connStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";";
conn = new OleDbConnection(connStr);
adp = new OleDbDataAdapter(sql, conn);
adp.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dataGridView1.Columns[4].DefaultCellStyle.Format = "c";
dataGridView1.Columns[6].Visible = false;
dataGridView1.Columns[7].Visible = false;
dataGridView1.Columns[8].Visible = false;
incom_rowcount = ds.Tables[0].Rows.Count;
adp2 = new OleDbDataAdapter(sql2, conn);
adp2.Fill(ds2);
dataGridView2.DataSource = ds2.Tables[0];
dataGridView2.Columns[2].DefaultCellStyle.Format = "c";
dataGridView2.Columns[4].Visible = false;
dataGridView2.Columns[5].Visible = false;
dataGridView2.Columns[6].Visible = false;
expen_rowcount = ds2.Tables[0].Rows.Count;
today_income.Text = dbhand.today_income_sum(today_date).ToString(); //금일수입금액
today_expend.Text = dbhand.today_expend_sum(today_date).ToString(); //금일지출금액
all_income.Text = dbhand.all_income_sum(today_date).ToString(); //총 수입 금액
all_expend.Text = dbhand.all_expend_sum(today_date).ToString(); //총 지출 금액
today_differ.Text = dbhand.today_difference(today_date).ToString(); //금일차액
Now_differ.Text = dbhand.all_difference(today_date).ToString(); //총 차액
yesterday.Text = dbhand.yesterday_sum(today_date.AddDays(-1)).ToString(); //이월금액
}
