SqlConnection con = new SqlConnection("Data Source=server;Initial Catalog=f_library;User ID=sa;Password=ahmed"); con.Open(); SqlDataAdapter dad = new SqlDataAdapter("Select * from absence where absent_b_date between @start and @end", con); dad.SelectCommand.Parameters.AddWithValue("@start", dateTimePicker1.Value); dad.SelectCommand.Parameters.AddWithValue("@end", dateTimePicker2.Value); DataTable mDT_Report = new DataTable(); ReportDocument cryRpt = new ReportDocument(); cryRpt.Load("G:\\WindowsApplication2\\WindowsApplication2\\CrystalReport6.rpt"); ParameterFieldDefinitions crParameterFieldDefinitions ; ParameterFieldDefinition crParameterFieldDefinition ; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = dateTimePicker1.Value; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["hireto"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = dateTimePicker2.Value; crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["hirefrom"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); dad.Fill(mDT_Report); cryRpt.Database.Tables[0].SetDataSource(mDT_Report); MessageBox.Show("Generating Report", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); crystalReportViewer1.ReportSource = cryRpt;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)