public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
RptEmployeeReport rpt = new RptEmployeeReport();
rpt.Site = this.Site;
return(rpt);
}
private void Button1_Click(object sender, EventArgs e)
{
try
{
if (txtSchool.Text == "")
{
MessageBox.Show("Please select school", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtSchool.Focus();
return;
}
if (txtDepartment.Text == "")
{
MessageBox.Show("Please Enter Session", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtDepartment.Focus();
return;
}
if (txtDesignation.Text == "")
{
MessageBox.Show("Please Enter Class", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtDesignation.Focus();
return;
}
try
{
Cursor = Cursors.WaitCursor;
Timer1.Enabled = true;
con = new SqlConnection(cs.DBcon);
con.Open();
cmd = new SqlCommand("SELECT Department.DepartmentName, Employee.EMPMAXID, Employee.EMPID, Employee.EmployeeName, Employee.Gender, Employee.DOB, Employee.FatherName, Employee.ContactNo, Employee.DateOfJoining,Employee.City, Employee.Country, Employee.Address, Employee.Salary, Employee.Status, Employee.BloodGroup, Employee.Religion, Employee.Photo, School.SchoolName, Designations.Designation FROM Employee INNER JOIN School ON Employee.SchoolID = School.SchoolID INNER JOIN Department ON Employee.Department_ID = Department.DepartmentID INNER JOIN Designations ON Employee.Designation_ID = Designations.DesignationID where SchoolName=@d1 and DepartmentName=@d2 and Designation=@d3 order by employeeName", con);
cmd.Parameters.AddWithValue("@d1", txtSchool.Text);
cmd.Parameters.AddWithValue("@d2", txtDepartment.Text);
cmd.Parameters.AddWithValue("@d3", txtDesignation.Text);
adp = new SqlDataAdapter(cmd);
DataTable table = new DataTable();
adp.Fill(table);
ds = new DataSet();
con.Close();
ds.Tables.Add(table);
ds.WriteXmlSchema("Employee.xml");
RptEmployeeReport rpt = new RptEmployeeReport();
rpt.SetDataSource(ds);
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
