public void ShowUserControl()
{
NTSDataContext dbCtx = new NTSDataContext();
var alarmList =
from alarm in dbCtx.AlarmTable
where alarm.AlarmCode == 10
select alarm;
dataGridView1.DataSource = alarmList;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public MainPage()
{
InitializeComponent();
NTSDataContext dbCtx = new NTSDataContext();
var alarmList =
from alarm in dbCtx.AlarmTable
where alarm.AlarmCode == 10
select alarm;
DateTime date = new DateTime(2020, 06, 16);
var alarmList2 =
from sensor1 in dbCtx.TM1_SENSOR1
where sensor1.ReceivedTime.Month == date.Month
select sensor1;
dataGridView1.DataSource = alarmList;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView2.DataSource = alarmList2;
dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}