public Alarm() { InitializeComponent(); string Query = "SELECT * FROM Events WHERE Type='Alarm'"; sqlOperation.SelectFromDB(Query, true); cbType.DataSource = sqlOperation.type; cbOperator.DataSource = sqlOperation.Operator; dataGridView1.DataSource = sqlOperation.dt; }
public History() { InitializeComponent(); sqlOperation = new SqlOp(); string Query = "SELECT * FROM Events"; //true=====select data from database and assign it in 2 lists: type & operator sqlOperation.SelectFromDB(Query, true); cbType.DataSource = sqlOperation.type; cbOperator.DataSource = sqlOperation.Operator; }
private void btnRefresh_Click(object sender, EventArgs e) { string Query; if (cbFilter.SelectedIndex == 0) { Query = "SELECT * FROM Events WHERE Type='" + cbType.Text + "'"; } else if (cbFilter.SelectedIndex == 1) { Query = "SELECT * FROM Events WHERE Operator='" + cbOperator.Text + "'"; } else { Query = "SELECT * FROM Events WHERE Date='" + dateTimePicker1.Value + "'"; } //false====Select data from database and not assign it in lists sqlOperation.SelectFromDB(Query, false); dataGridView1.DataSource = sqlOperation.dt; }