private Int32 GetSelectedThresholdId() { DataRowView dataRow = (DataRowView)cmbBoxThresholdTypes.SelectedItem; LinqExample.SLA_RT_monitoringDataSetThreshold.ThresholdsRow selectedRow = (LinqExample.SLA_RT_monitoringDataSetThreshold.ThresholdsRow)dataRow.Row; return(selectedRow.id); }
//Run when select devices from the list private void cmbBoxThresholdTypes_SelectedIndexChanged(object sender, EventArgs e) { SqlDataReader measurementsReader = null; DataRowView dataRow = (DataRowView)cmbBoxThresholdTypes.SelectedItem; LinqExample.SLA_RT_monitoringDataSetThreshold.ThresholdsRow selectedRow = (LinqExample.SLA_RT_monitoringDataSetThreshold.ThresholdsRow)dataRow.Row; measurmentsSqlCommand.Parameters[0].Value = selectedRow.id; global::System.Data.ConnectionState previousConnectionState = measurmentsSqlCommand.Connection.State; if (((measurmentsSqlCommand.Connection.State & global::System.Data.ConnectionState.Open) != global::System.Data.ConnectionState.Open)) { measurmentsSqlCommand.Connection.Open(); } try { measurementsReader = measurmentsSqlCommand.ExecuteReader(); } catch (Exception e123) { MessageBox.Show(e123.ToString()); } listDevices.Items.Clear(); while (measurementsReader.Read()) { listDevices.Items.Add(measurementsReader.GetString(0)); } if (listDevices.Items.Count > 0) { listDevices.SelectedItems.Add(listDevices.Items[0]); } measurementsReader.Close();//Close the reader since we are opening it every time when selected item CreateGraph(zg1); }