public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptLoging rpt = new rptLoging(); rpt.Site = this.Site; return(rpt); }
private void btnShow_Click(object sender, EventArgs e) { Community.DBLayer dbLayer = new Community.DBLayer(); try { DateTime startdate = Convert.ToDateTime(dtpFrom.Text); string time = startdate.TimeOfDay.ToString(); DateTime enddate = Convert.ToDateTime(dtpTo.Text); enddate = enddate.AddDays(1); SqlConnection con = new SqlConnection(Community.DBLayer.con_String); con.Open(); SqlCommand cmd = new SqlCommand("Select tblSecurity.UserName,LoginTime,LogoffTime FROM tblLoging INNER JOIN tblSecurity ON tblLoging.UserID = tblSecurity.UserID WHERE LoginTime >='" + startdate + "' AND LoginTime <= '" + enddate + "'", con); DataTable dt = new DataTable(); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); MCKJ.Reports.Loging.frmViewer frm = new frmViewer(); MCKJ.Reports.Loging.rptLoging rpt = new rptLoging(); rpt.SetDataSource(dt); frm.crystalReportViewer1.ReportSource = rpt; frm.Show(); con.Close(); } catch (FormatException) { MessageBox.Show("Only Numbers are allowed!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }