listView添加 修改 删除 保存数据到数据库操作

界面设计样式：

 

界面运行时样式：

 

GroupBox1中的是listView1，GroupBox2中的是listView2

 

具体操作代码如下：

 

 using System;<br />using System.Collections.Generic;<br />using System.ComponentModel;<br />using System.Data;<br />using System.Drawing;<br />using System.Linq;<br />using System.Text;<br />using System.Windows.Forms;<br />using System.Data.OleDb;<br /><br />namespace Porject_test_1<br />{<br /> public partial class Form4 : Form<br /> {<br /> public Form4()<br /> {<br /> InitializeComponent();<br /> }<br /><br /> private OleDbConnection Con()<br /> {<br /> string ConString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Kword.mdb";<br /> OleDbConnection Conn = new OleDbConnection(ConString);<br /> Conn.Open();<br /> return Conn;<br /> }<br /><br /> private void Form4_Load(object sender, EventArgs e)<br /> {<br /> OleDbConnection conn = Con();<br /> OleDbCommand com = new OleDbCommand();<br /> com.Connection = conn;<br /> com.CommandText = @"select distinct id from Kword";<br /><br /> OleDbDataReader oleRd = com.ExecuteReader();<br /> while (oleRd.Read())<br /> {<br /> listView1.Items.Add(oleRd[0].ToString());<br /> }<br /> }<br /><br /> //点击listView控件中的元素响应<br /> private void listView1_ItemActivate(object sender, EventArgs e)<br /> {<br /> listView2.Items.Clear();<br /> string i = listView1.SelectedItems[0].SubItems[0].Text;<br /><br /> OleDbConnection Conn = Con();<br /> string query = @"select * from Kword where id=@i";<br /><br /> OleDbCommand com = new OleDbCommand(query, Conn);<br /> com.Parameters.Add("@i", OleDbType.Variant, 10).Value = i;<br /><br /> OleDbDataReader DR = com.ExecuteReader();<br /> while (DR.Read())<br /> {<br /> ListViewItem li = new ListViewItem();<br /> li.SubItems.Clear();<br /><br /> li.SubItems[0].Text = DR[0].ToString();<br /> li.SubItems.Add(DR[1].ToString());<br /><br /> listView2.Items.Add(li);<br /> }<br /><br /> }<br /><br /> //添加组按钮操作<br /> private void button1_Click(object sender, EventArgs e)<br /> {<br /> AddGroup frm = new AddGroup();<br /> frm.ShowDialog();<br /><br /> int i;<br /> for (i = 0; i < listView1.Items.Count; i++)<br /> {<br /> if (frm.GName == listView1.Items[i].Text)<br /> break;<br /> }<br /> if (i < listView1.Items.Count)<br /> MessageBox.Show("输入的组已有，请重新输入");<br /> else<br /> listView1.Items.Add(frm.GName);<br /><br /> }<br /><br /> //删除组按钮操作<br /> private void button2_Click(object sender, EventArgs e)<br /> {<br /> if (listView1.SelectedItems.Count != 0)<br /> {<br /> DialogResult dlgResult;<br /> dlgResult = MessageBox.Show("确定要删除该组？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk);<br /> if (dlgResult == DialogResult.Yes)<br /> {<br /> OleDbConnection conn = Con();<br /><br /> string query = @"delete from Kword where ID=@GN";<br /> OleDbCommand com = new OleDbCommand();<br /> com.Connection = conn;<br /> com.CommandText = query;<br /> com.Parameters.Add("@GN", OleDbType.Variant, 10).Value = listView1.SelectedItems[0].Text;<br /> com.ExecuteNonQuery();<br /> listView1.SelectedItems[0].Remove();<br /> MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);<br /> //MessageBox.Show(listView1.SelectedItems[0].Text);<br /> }<br /> }<br /> else<br /> MessageBox.Show("请先选择要删除的组名！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);<br /> }<br /><br /> //添加按钮操作<br /> private void button3_Click(object sender, EventArgs e)<br /> {<br /> if (listView1.SelectedItems.Count > 0)<br /> {<br /> AddItem frm = new AddItem();<br /> frm.ShowDialog();<br /><br /> if (frm.IName != null)<br /> {<br /> ListViewItem It = new ListViewItem();<br /> It.SubItems[0].Text = listView1.SelectedItems[0].Text;<br /> It.SubItems.Add(frm.IName);<br /> listView2.Items.Add(It);<br /> }<br /><br /> }<br /> }<br /><br /> //删除按钮操作<br /> private void button4_Click(object sender, EventArgs e)<br /> {<br /> int count = listView2.SelectedItems.Count;<br /> for (int i = 0; i < count; count--)<br /> {<br /> listView2.SelectedItems[0].Remove();<br /> }<br /> }<br /><br /> //保存按钮操作<br /> private void button5_Click(object sender, EventArgs e)<br /> {<br /> if (listView1.SelectedItems.Count != 0)<br /> {<br /> MessageBox.Show(listView2.Items[0].Text);<br /> MessageBox.Show(listView2.Items[1].SubItems[1].Text);<br /><br /> OleDbConnection conn = Con();<br /> string delString = @"delete from Kword where ID=@IdName";<br /> string inString = @"insert into Kword (ID,Keyword) values (@idvalue,@keyword)";<br /><br /> OleDbCommand com = new OleDbCommand();<br /> com.Connection = conn;<br /> com.CommandText = delString;<br /> com.Parameters.Add("@IdName", OleDbType.Variant, 10).Value = listView1.SelectedItems[0].Text;<br /> com.ExecuteNonQuery();<br /><br /> com.CommandText = inString;<br /> com.Prepare();<br /><br /> foreach (ListViewItem li in listView2.Items)<br /> {<br /> com.Parameters.Clear();<br /> com.Parameters.Add("@idvalue", OleDbType.Variant, 10).Value = li.Text;<br /> com.Parameters.Add("@keyword", OleDbType.Variant, 50).Value = li.SubItems[1].Text;<br /> com.ExecuteNonQuery();<br /> }<br /><br /> }<br /> }<br /><br /> //修改按钮操作<br /> private void button6_Click(object sender, EventArgs e)<br /> {<br /> if (listView2.SelectedItems.Count == 1)<br /> {<br /> AddItem frm = new AddItem();<br /> frm.ShowDialog();<br /><br /> if (frm.IName != null)<br /> {<br /> listView2.SelectedItems[0].SubItems[1].Text = frm.IName;<br /> }<br /> }<br /> else<br /> MessageBox.Show("请先选择要修改的某一行！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);<br /> }<br /> }<br />}<br />