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;
}
