private void SCButton_Click(object sender, EventArgs e)//删除通讯录 { sql = new SqlHelp("data source=mydb.db"); if (ListView.SelectedItems.Count > 0) { string name = this.ListView.FocusedItem.SubItems[0].Text; sql.DeleteValuesAND("tongxunlu", new string[] { "Name" }, new string[] { name }, new string[] { "=" }); ListView.Items.Clear(); //读取整张表 SQLiteDataReader reader = sql.ReadFullTable("tongxunlu"); this.ListView.BeginUpdate(); //数据更新,UI暂时挂起,直到EndUpdate绘制控件,可以有效避免闪烁并大大提高加载速度 while (reader.Read()) { ListViewItem lvi = new ListViewItem(); lvi.Text = reader.GetString(reader.GetOrdinal("Name")); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone"))); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups"))); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email"))); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ"))); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin"))); lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info"))); this.ListView.Items.Add(lvi); } this.ListView.EndUpdate(); //结束数据处理,UI界面一次性绘制。 sql.CloseConnection(); sql.CloseConnection(); ImageList imgList = new ImageList(); imgList.ImageSize = new Size(1, 35);//分别是宽和高 ListView.SmallImageList = imgList; MessageBox.Show("删除成功"); } }
private void Delfenlei_Click(object sender, EventArgs e)//删除分组 { sql = new SqlHelp("data source=mydb.db"); sql.DeleteValuesAND("fenzu", new string[] { "Name" }, new string[] { Listfenzu.SelectedItem.ToString() }, new string[] { "=" }); Listfenzu.Items.Clear(); SQLiteDataReader reader = sql.ReadFullTable("fenzu"); while (reader.Read()) { Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name"))); } sql.CloseConnection(); MessageBox.Show("删除成功"); }