/// <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);
}
