public void Main_Load(object sender, EventArgs e)//初始化加载 { sql = new SqlHelp("data source=mydb.db"); sql.CreateTable("tongxunlu", new string[] { "Name", "Phone", "Groups", "Email", "QQ", "Weixin", "Info" }, new string[] { "TEXT", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT" }); //读取整张表 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; }
private void XJButton_Click(object sender, EventArgs e)//新建通讯录 { Add f2 = new Add(); f2.ShowDialog(); if (f2.DialogResult == DialogResult.OK) { ListView.Items.Clear(); sql = new SqlHelp("data source=mydb.db"); //读取整张表 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; } }
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 Listfenzu_Click(object sender, EventArgs e) { if (this.Listfenzu.SelectedItems.Count > 0) { sql = new SqlHelp("data source=mydb.db"); ListView.Items.Clear(); SQLiteDataReader reader = sql.ReadFullTable("tongxunlu"); this.ListView.BeginUpdate(); //数据更新,UI暂时挂起,直到EndUpdate绘制控件,可以有效避免闪烁并大大提高加载速度 while (reader.Read()) { if (reader.GetString(reader.GetOrdinal("Groups")) == Listfenzu.SelectedItem.ToString()) { 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; } }
public Main() { InitializeComponent(); sql = new SqlHelp("data source=mydb.db");//初始化加分组 SQLiteDataReader reader = sql.ReadFullTable("fenzu"); while (reader.Read()) { Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name"))); } sql.CloseConnection(); }
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("删除成功"); }
public Add() { InitializeComponent(); sql = new SqlHelp("data source=mydb.db"); SQLiteDataReader reader = sql.ReadFullTable("fenzu"); while (reader.Read()) { int i = 0; tfenlei.Items.Insert(i, reader.GetString(reader.GetOrdinal("Name"))); i++; } sql.CloseConnection(); }
private void SouOK_Click(object sender, EventArgs e) { if (SouContent.Text.Trim().Length == 0) { MessageBox.Show("请务必选择分组"); } else { string SouFenzu = SouContent.SelectedItem.ToString(); if (SouFenzu == "姓名") { SouFenzu = "Name"; } if (SouFenzu == "手机号") { SouFenzu = "Phone"; } if (SouFenzu == "邮箱") { SouFenzu = "Email"; } if (SouFenzu == "QQ") { SouFenzu = "QQ"; } if (SouFenzu == "微信") { SouFenzu = "Weixin"; } sql = new SqlHelp("data source=mydb.db"); //string strsql = "SELECT FROM tongxunlu WHERE " + SouFenzu + "=" + "'" + SuoContent.Text + "'"; //不会写,最后干脆线搜索全表,显示需要的信息,反正数据不多! SQLiteDataReader reader = sql.ReadFullTable("tongxunlu"); bool tf = false; while (reader.Read()) { if (reader.GetString(reader.GetOrdinal(SouFenzu)) == SuoContent.Text) { MessageBox.Show("(姓名:" + reader.GetString(reader.GetOrdinal("Name")) + ")" + "(手机号:" + reader.GetString(reader.GetOrdinal("Phone")) + ")" + "(邮箱:" + reader.GetString(reader.GetOrdinal("Email")) + ")" + "(QQ:" + reader.GetString(reader.GetOrdinal("QQ")) + ")" + "(微信:" + reader.GetString(reader.GetOrdinal("Weixin")) + ")"); tf = true; } } if (!tf) { MessageBox.Show("没有查询到内容!"); } sql.CloseConnection(); } }
private void Newfenlei_Click(object sender, EventArgs e)//添加分组 { Newfenlei f = new Newfenlei(); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { Listfenzu.Items.Clear(); sql = new SqlHelp("data source=mydb.db"); SQLiteDataReader reader = sql.ReadFullTable("fenzu"); while (reader.Read()) { Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name"))); } sql.CloseConnection(); } }
public XGview() { InitializeComponent(); tname.Text = InfoClass.TName; tphone.Text = InfoClass.Phone; temail.Text = InfoClass.Email; tqq.Text = InfoClass.QQ; tweixin.Text = InfoClass.Weixin; tbeizhu.Text = InfoClass.Info; sql = new SqlHelp("data source=mydb.db"); SQLiteDataReader reader = sql.ReadFullTable("fenzu"); while (reader.Read()) { int i = 0; tfenlei.Items.Insert(i, reader.GetString(reader.GetOrdinal("Name"))); i++; } sql.CloseConnection(); }
private void XGButton_Click(object sender, EventArgs e) { if (ListView.SelectedItems.Count > 0) { InfoClass.TName = ListView.FocusedItem.SubItems[0].Text; InfoClass.Phone = ListView.FocusedItem.SubItems[1].Text; InfoClass.Email = ListView.FocusedItem.SubItems[3].Text; InfoClass.QQ = ListView.FocusedItem.SubItems[4].Text; InfoClass.Weixin = ListView.FocusedItem.SubItems[5].Text; InfoClass.Info = ListView.FocusedItem.SubItems[6].Text; XGview f = new XGview(); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { sql = new SqlHelp("data source=mydb.db"); 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("修改成功"); } } }