/// <summary> /// Name:EmployeeCrystalReport_Load /// Description:Bind ComboBox /// Author:Monal shah /// Created Date:2010/12/13 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void EmployeeCrystalReport_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'northwind_MonalDataSet.DetailsOfEmployee' table. You can move, or remove it, as needed. EmployeesCrystalReport objemp = new EmployeesCrystalReport(); DataTable objdt = new DataTable(); try { crystalReportViewer1.ReportSource = objemp; comboSalary.Enabled = false; datePickerCombo.Enabled = false; string query = ConstantMessage.SalaryBindQuery; objAdp = new SqlDataAdapter(query, con); objAdp.Fill(objdt); comboSalary.DataSource = objdt; comboSalary.DisplayMember = "Salary"; comboSalary.ValueMember = "Salary"; textBox1.Enabled = true; string query1 = ConstantMessage.FieldBindQuery; objAdp1 = new SqlDataAdapter(query1, con); objdt1 = new DataTable(); objAdp1.Fill(objdt1); comboField.DataSource = objdt1; comboField.DisplayMember = "COLUMN_NAME"; comboField.ValueMember = "COLUMN_NAME"; } finally { objdt1 = null; objAdp1 = null; objdt = null; objAdp = null; con = null; } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { EmployeesCrystalReport rpt = new EmployeesCrystalReport(); rpt.Site = this.Site; return(rpt); }