Beispiel #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            BulanTerbaik rpt = new BulanTerbaik();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void FormBulanTerbaik_Load(object sender, EventArgs e)
        {
            this.FormBorderStyle  = System.Windows.Forms.FormBorderStyle.None;
            conn.ConnectionString = "User ID=proyek;Password=1;Data Source=orcl";
            try
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                    conn.ConnectionString = "User ID=proyek;Password=1;Data Source=orcl";
                    conn.Open();
                }
                else
                {
                    conn.ConnectionString = "User ID=proyek;Password=1;Data Source=orcl";
                    conn.Open();
                }
                conn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

            OracleCommand cmd = new OracleCommand();

            cmd.Connection = conn;
            //nama
            cmd.CommandText = "";


            BulanTerbaik rep = new BulanTerbaik();

            rep.SetDatabaseLogon("proyek", "1");
            rep.SetParameterValue("bulan", TransaksiTerbanyak());
            crystalReportViewer1.ReportSource = rep;
        }