Exemplos de DBCommand.DataTableTransaksi em C# (CSharp)

Exemplo n.º 1

        public void DisplayReport()
        {
            DataTable dt = null;

            if (apoteker == null && tgl == null)
            {
                dt = cmd.DataTableTransaksi();
            }

            if ((apoteker == null) & (tgl != null))
            {
                dt = cmd.DataTableTransaksiByTgl(tgl);
            }

            if ((apoteker != null) & (tgl == null))
            {
                dt = cmd.DataTableTransaksiByApoteker(apoteker);
            }

            if ((apoteker != null) & (tgl != null))
            {
                dt = cmd.DataTableTransaksiByApotekerTgl(apoteker, tgl);
            }

            rpt.Reset();
            var ds = new ReportDataSource("DataTransaksi", dt);

            rpt.LocalReport.DataSources.Add(ds);
            rpt.LocalReport.ReportPath = @"report\LaporanTransaksi.rdlc";
            rpt.SetDisplayMode(DisplayMode.PrintLayout);
            rpt.RefreshReport();
        }