MySqlConnection conn = new MySqlConnection("SERVER=localhost;DATABASE=akunting;UID=root;PWD=");
            MySqlDataAdapter da = new MySqlDataAdapter("select no_perkiraan,nama_perkiraan from perkiraan",conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            int n = 0;
            for(int i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr = dt.Rows[i];
                n = dataGridView1.Rows.Add();
                dataGridView1.Rows[n].Cells[0].Value = dr["no_perkiraan"].ToString();
                dataGridView1.Rows[n].Cells[1].Value = dr["nama_perkiraan"].ToString();
            }
            n = dataGridView1.Rows.Add();
            dataGridView1.Rows[n].Cells[0].Value = "Total";
            dataGridView1.Rows[n].Cells[1].Value = "15";