protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["eventId"] != null) { postedEventId = Request["eventId"]; using (MeterDataQualitySummaryTableAdapter meterdataqualityAdapter = new DbAdapterContainer(connectionstring).GetAdapter <MeterDataQualitySummaryTableAdapter>()) using (MeterInfoDataContext meterInfo = new MeterInfoDataContext(connectionstring)) { try { DataQuality.MeterDataQualitySummaryRow theevent = meterdataqualityAdapter.GetDataByID(Convert.ToInt32(postedEventId)).First(); Meter themeter = meterInfo.Meters.Single(m => m.ID == theevent.MeterID); postedDate = theevent.Date.ToShortDateString(); postedMeterId = theevent.MeterID.ToString(); postedMeterName = themeter.Name; } catch (Exception ex) { postedDate = ""; postedEventId = ""; postedMeterId = ""; postedMeterName = ""; } finally { } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["eventId"] != null) { postedEventId = Request["eventId"]; using(MeterDataQualitySummaryTableAdapter meterdataqualityAdapter = new DbAdapterContainer(connectionstring).GetAdapter<MeterDataQualitySummaryTableAdapter>()) using (MeterInfoDataContext meterInfo = new MeterInfoDataContext(connectionstring)) { try { DataQuality.MeterDataQualitySummaryRow theevent = meterdataqualityAdapter.GetDataByID(Convert.ToInt32(postedEventId)).First(); Meter themeter = meterInfo.Meters.Single(m => m.ID == theevent.MeterID); postedDate = theevent.Date.ToShortDateString(); postedMeterId = theevent.MeterID.ToString(); postedMeterName = themeter.Name; } catch (Exception ex) { postedDate = ""; postedEventId = ""; postedMeterId = ""; postedMeterName = ""; } finally { } } } } }