public Logs() { InitializeComponent(); SetListviewBorder(); StartTime = Insert2DataBase.DateTimeToStamp(dateTimePicker1.Value.ToShortDateString()); EndTime = Insert2DataBase.DateTimeToStamp(dateTimePicker2.Value.ToShortDateString()); InitCombox(); }
private void Datatable2ListView(DataTable dt) { listView1.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { string[] str = new string[] { (i + 1).ToString(), dt.Rows[i][0].ToString(), dt.Rows[i][3].ToString(), Insert2DataBase.StampToDateTime(dt.Rows[i][2].ToString()), dt.Rows[i][1].ToString() }; ListViewItem lit = new ListViewItem(str); listView1.Items.Add(lit); } }
private void button2_Click(object sender, EventArgs e) { if (MessageBox.Show("是否确认删除? 注意!删除后将无法恢复!", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No) { return; } if (listView1.CheckedItems.Count > 0) { foreach (ListViewItem LVI in listView1.CheckedItems) { string strCMD = "delete from Logs_Data where CTime = " + Insert2DataBase.DateTimeToStamp(LVI.SubItems[3].Text) + ""; helper.Oledbcommand(strCMD); } } //------------------------------------------- listView1.Items.Clear(); InitData(); }
private void dateTimePicker2_ValueChanged(object sender, EventArgs e) { EndTime = Insert2DataBase.DateTimeToStamp(dateTimePicker2.Value.ToShortDateString()); InitData(); }