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("删除成功");
}
