//---To get the details from the N4 data base based on the Date of Event----End-----Carrier Out Bound Intended Change //---To get the details from the N4 data base based on the Date of Event----Start-----Destination Change public void getDataForDestinationChange() { DateTime fdt = Convert.ToDateTime(FromTimeDateTimePicker.Value.ToString()); string fromdt = fdt.ToString("dd-MM-yy HH:MM"); DateTime tdt = Convert.ToDateTime(ToTimeDateTimePicker.Value.ToString()); string todt = tdt.ToString("dd-MM-yy HH:MM"); string CONN_STRING = ConfigurationManager.ConnectionStrings["con1"].ConnectionString; OleDbConnection dbCon = new OleDbConnection(CONN_STRING); dbCon.Open(); string Query = "SELECT g.DES Change, a.placed_time ChangeTime,a.APPLIED_TO_NATURAL_KEY ContainerNo, b.prior_value FromValue, b.new_value ToValue,f.ID Line, " + "c.FREIGHT_KIND Freight,c.CATEGORY Category,e.ID Facility,c.GOODS_AND_CTR_WT_KG Wt, a.note Note " + "FROM navis.SRV_EVENT a, " + "navis.SRV_EVENT_FIELD_CHANGES b, " + "navis.INV_UNIT c, " + "navis.SRV_EVENT_TYPES d, " + "navis.ARGO_FACILITY e, " + "navis.REF_BIZUNIT_SCOPED f, " + "NAVIS.KPCL_EVENT g " + "WHERE a.gkey = b.EVENT_GKEY AND " + "a.APPLIED_TO_NATURAL_KEY = c.ID " + "AND a.EVENT_TYPE_GKEY = d.GKEY " + "AND a.FACILITY_GKEY = e.GKEY " + "AND c.LINE_OP = f.GKEY " + "AND b.METAFIELD_ID=g.NAME " + "AND b.METAFIELD_ID='gdsDestination'" + "and a.placed_time between TO_TIMESTAMP ('" + fromdt + "', 'DD/MM/RR HH24:MI:SS.FF')and TO_TIMESTAMP ('" + todt + "', 'DD/MM/RR HH24:MI:SS.FF')"; OleDbCommand cmd = new OleDbCommand(Query, dbCon); OleDbDataAdapter da = new OleDbDataAdapter(cmd); OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(da); dt.Locale = System.Globalization.CultureInfo.InvariantCulture; da.Fill(dt); da.Fill(ds, "Query"); kryptonDataGridView1.DataMember = "Query"; kryptonDataGridView1.DataSource = ds; kryptonDataGridView1.Visible = true; DataSet dataReport = new DataSet(); da.Fill(dataReport, "DataTable"); BillableEventsReport myDataReport = new BillableEventsReport(); myDataReport.SetDataSource(dataReport); rptBillableEventsReport.ReportSource = myDataReport; dbCon.Close(); }