private void btnDownload_Click(object sender, EventArgs e) { if (TemperatureRecords == null) { MessageBox.Show("Please Open the database first !"); } else { using (var sfd = new SaveFileDialog()) { if (sfd.ShowDialog() == DialogResult.OK) { CsvHelper.Export(sfd.FileName, TemperatureRecords); } } MessageBox.Show("Download Complete"); } }
private void btnCsv_Click(object sender, EventArgs e) { TemperatureRecords?.Clear(); try { using (var ofd = new OpenFileDialog() { Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false }) { if (ofd.ShowDialog() == DialogResult.OK) { var temp = CsvHelper.Import(ofd.FileName); TemperatureRecords = new List <TemperatureRecord>(); foreach (var item in temp) { var key = Guid.NewGuid().ToString(); //MessageBox.Show(key); TemperatureRecords.Add(new TemperatureRecord() { ID = key, 時間 = Convert.ToDateTime(item.時間), 第1段溫度顯示值 = Convert.ToDouble(item.第1段溫度顯示值), 第2段溫度顯示值 = Convert.ToDouble(item.第2段溫度顯示值), 第3段溫度顯示值 = Convert.ToDouble(item.第3段溫度顯示值), 第4段溫度顯示值 = Convert.ToDouble(item.第4段溫度顯示值), 第5段溫度顯示值 = Convert.ToDouble(item.第5段溫度顯示值), 第6段溫度顯示值 = Convert.ToDouble(item.第6段溫度顯示值) }); } dataGridView1.DataSource = TemperatureRecords; dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dataGridView1.Columns["ID"].Visible = false; FileName = ofd.FileName; } } } catch (Exception exception) { MessageBox.Show(exception.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }