ListView 连接数据库的增删改查

string link = "server=.;database=list;user=sa;pwd=123"; public void chaxun() //创建一个查询函数 { SqlConnection coon = new SqlConnection(link); //连接数据库 coon.Open();//打开数据库 SqlCommand cmd = coon.CreateCommand();//创建命令 cmd.CommandText = "select * from listview";//写命令内容 SqlDataReader dr = cmd.ExecuteReader();//执行命令 int index = 0; //定义listview.Items的索引 listView1.Items.Clear(); //先将listView1.Items清空; while (dr.Read()) //循环条件,里面有数据 { //将数据一条一条增加到listView.Items的集合中 listView1.Items.Add(dr["code"].ToString());//Items代表的是每列 listView1.Items[index].SubItems.Add(dr["name"].ToString());//SubItems其他列 listView1.Items[index].SubItems.Add(dr["pass"].ToString()); index++; } cmd.Dispose(); coon.Close(); }

 <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button1_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">查询</span>
<span style="color: #000000;">        {
            SqlConnection coon </span>= <span style="color: #0000ff;">new</span> SqlConnection(link);<span style="color: #008000;">//</span><span style="color: #008000;">连接数据库</span>
            coon.Open();<span style="color: #008000;">//</span><span style="color: #008000;">打开数据库</span>
            SqlCommand cmd = coon.CreateCommand();<span style="color: #008000;">//</span><span style="color: #008000;">创建命令</span>
            cmd.CommandText = <span style="color: #800000;">"</span><span style="color: #800000;">select * from listview</span><span style="color: #800000;">"</span>;<span style="color: #008000;">//</span><span style="color: #008000;">写命令内容</span>
            SqlDataReader dr = cmd.ExecuteReader();<span style="color: #008000;">//</span><span style="color: #008000;">执行命令</span>
            <span style="color: #0000ff;">int</span> index = <span style="color: #800080;">0</span>;<span style="color: #008000;">//</span><span style="color: #008000;">定义listview.Items的索引</span>
            listView1.Items.Clear();<span style="color: #008000;">//</span><span style="color: #008000;">先将listView1.Items清空;</span>
            <span style="color: #0000ff;">while</span> (dr.Read())<span style="color: #008000;">//</span><span style="color: #008000;">循环条件,里面有数据</span>
            {   <span style="color: #008000;">//</span><span style="color: #008000;">将数据一条一条增加到listView.Items的集合中</span>
                listView1.Items.Add(dr[<span style="color: #800000;">"</span><span style="color: #800000;">code</span><span style="color: #800000;">"</span>].ToString());<span style="color: #008000;">//</span><span style="color: #008000;">Items代表的是每列</span>
                listView1.Items[index].SubItems.Add(dr[<span style="color: #800000;">"</span><span style="color: #800000;">name</span><span style="color: #800000;">"</span>].ToString());<span style="color: #008000;">//</span><span style="color: #008000;">SubItems其他列</span>
                listView1.Items[index].SubItems.Add(dr[<span style="color: #800000;">"</span><span style="color: #800000;">pass</span><span style="color: #800000;">"</span><span style="color: #000000;">].ToString());
                index</span>++;<span style="color: #008000;">//</span><span style="color: #008000;">索引++ ，再循环</span>
<span style="color: #000000;">            }
            cmd.Dispose();</span><span style="color: #008000;">//</span><span style="color: #008000;">命令清空</span>
            coon.Close(); <span style="color: #008000;">//</span><span style="color: #008000;">数据库关闭</span>
        }

 

 

 

 <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button2_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">删除</span>
<span style="color: #000000;">        {
            
            </span><span style="color: #0000ff;">if</span>(listView1.SelectedItems.Count><span style="color: #800080;">0</span>) <span style="color: #008000;">//</span><span style="color: #008000;">如果选中的要删除数据的数量大于0才可以执行删除,否则不执行</span>
            {   <span style="color: #0000ff;">string</span> scode = listView1.SelectedItems[<span style="color: #800080;">0</span>].Text.ToString(); <span style="color: #008000;">//</span><span style="color: #008000;">创建一个变量来接收第一列索引的文本内容</span>
                SqlConnection coon = <span style="color: #0000ff;">new</span> SqlConnection(link);<span style="color: #008000;">//</span><span style="color: #008000;">连接数据库</span>
                coon.Open();<span style="color: #008000;">//</span><span style="color: #008000;">打开数据库</span>
                SqlCommand cmd = coon.CreateCommand();<span style="color: #008000;">//</span><span style="color: #008000;">创建命令</span>
                cmd.CommandText = <span style="color: #800000;">"</span><span style="color: #800000;">delete from listview where code=‘</span><span style="color: #800000;">"</span> + scode + <span style="color: #800000;">"</span><span style="color: #800000;">‘</span><span style="color: #800000;">"</span>;<span style="color: #008000;">//</span><span style="color: #008000;">写命令内容</span>
                cmd.ExecuteNonQuery(); <span style="color: #008000;">//</span><span style="color: #008000;">执行命令       </span>
                cmd.Dispose();<span style="color: #008000;">//</span><span style="color: #008000;">命令清空</span>
                coon.Close();<span style="color: #008000;">//</span><span style="color: #008000;">数据库关闭</span>
                chaxun(); <span style="color: #008000;">//</span><span style="color: #008000;">执行查询函数</span>
<span style="color: #000000;">            }
            
        }</span>

 

 

 

<span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button3_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">主页增加按钮</span>
<span style="color: #000000;">        {
            add f </span>= <span style="color: #0000ff;">new</span><span style="color: #000000;"> add();
            f.Show(); </span><span style="color: #008000;">//</span><span style="color: #008000;">弹出增加框</span>
        }

 <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button1_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">增加</span>
        {   <span style="color: #0000ff;">if</span>(textBox2.Text!=<span style="color: #0000ff;">null</span>&&textBox3.Text!=<span style="color: #0000ff;">null</span>) <span style="color: #008000;">//</span><span style="color: #008000;">只有当文本栏不为空才能执行增加,否则点增加没反应</span>
<span style="color: #000000;">            {
            </span><span style="color: #0000ff;">string</span> code=textBox1.Text; <span style="color: #008000;">//</span><span style="color: #008000;">第一栏的文本</span>
            <span style="color: #0000ff;">string</span> name=textBox2.Text; <span style="color: #008000;">//</span><span style="color: #008000;">第二栏的文本</span>
            <span style="color: #0000ff;">string</span> pass=textBox3.Text; <span style="color: #008000;">//</span><span style="color: #008000;">第三栏的文本</span>
            SqlConnection coon = <span style="color: #0000ff;">new</span> SqlConnection(<span style="color: #800000;">"</span><span style="color: #800000;">server=.;database=list;user=sa;pwd=123</span><span style="color: #800000;">"</span>);<span style="color: #008000;">//</span><span style="color: #008000;">连接数据库</span>
            coon.Open();<span style="color: #008000;">//</span><span style="color: #008000;">打开数据库</span>
            SqlCommand cmd = coon.CreateCommand();<span style="color: #008000;">//</span><span style="color: #008000;">创建命令</span>
            cmd.CommandText = <span style="color: #800000;">"</span><span style="color: #800000;">insert into listview values(‘</span><span style="color: #800000;">"</span>+name+<span style="color: #800000;">"</span><span style="color: #800000;">‘,‘</span><span style="color: #800000;">"</span>+pass+<span style="color: #800000;">"</span><span style="color: #800000;">‘)</span><span style="color: #800000;">"</span>;<span style="color: #008000;">//</span><span style="color: #008000;">写命令语句</span>
            cmd.ExecuteNonQuery();<span style="color: #008000;">//</span><span style="color: #008000;">执行命令</span>
            cmd.Dispose();<span style="color: #008000;">//</span><span style="color: #008000;">清空命令</span>
            coon.Close();<span style="color: #008000;">//</span><span style="color: #008000;">关闭数据库</span>
            MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">增加成功</span><span style="color: #800000;">"</span><span style="color: #000000;">);
            }
        }</span>

 

 

 

 

<span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button4_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">主页修改按钮</span>
<span style="color: #000000;">        {
            </span><span style="color: #0000ff;">if</span>(listView1.SelectedItems.Count><span style="color: #800080;">0</span>) <span style="color: #008000;">//</span><span style="color: #008000;">选中要修改的内容才能执行修改</span>
<span style="color: #000000;">            {
            </span><span style="color: #0000ff;">string</span> code = listView1.SelectedItems[<span style="color: #800080;">0</span>].Text; <span style="color: #008000;">//</span><span style="color: #008000;">将所选中文本的第一列的内容赋给code</span>
            update f = <span style="color: #0000ff;">new</span> update(code);<span style="color: #008000;">//</span><span style="color: #008000;">将code扔进去 是为了让修改窗体接收这个code值 （鼠标右键 转到定义）</span>
<span style="color: #000000;">            f.Show();
            }
        }</span>

 <span style="color: #0000ff;">private</span> <span style="color: #0000ff;">string</span><span style="color: #000000;"> Code;
        </span><span style="color: #0000ff;">public</span> update(<span style="color: #0000ff;">string</span> code) <span style="color: #008000;">//</span><span style="color: #008000;">将主页面所选中内容的code值传给窗体update,并且显示在窗体update的第一栏文本内</span>
<span style="color: #000000;">        {
            InitializeComponent();
            Code </span>= code;<span style="color: #008000;">//</span><span style="color: #008000;">传值</span>
            textBox1.Text = Code;<span style="color: #008000;">//</span><span style="color: #008000;">显示</span>
<span style="color: #000000;">        }
        </span><span style="color: #0000ff;">private</span> <span style="color: #0000ff;">void</span> button1_Click(<span style="color: #0000ff;">object</span> sender, EventArgs e) <span style="color: #008000;">//</span><span style="color: #008000;">修改</span>
<span style="color: #000000;">        {   
            </span><span style="color: #0000ff;">if</span>(textBox2.Text!=<span style="color: #0000ff;">null</span>&&textBox3.Text!=<span style="color: #0000ff;">null</span>) <span style="color: #008000;">//</span><span style="color: #008000;">只有当文本栏内容不为空才会执行修改</span>
<span style="color: #000000;">            {
            </span><span style="color: #0000ff;">string</span> name = textBox2.Text;<span style="color: #008000;">//</span><span style="color: #008000;">第二栏文本</span>
            <span style="color: #0000ff;">string</span> pass = textBox3.Text;<span style="color: #008000;">//</span><span style="color: #008000;">第三栏文本</span>
            SqlConnection coon = <span style="color: #0000ff;">new</span> SqlConnection(<span style="color: #800000;">"</span><span style="color: #800000;">server=.;database=list;user=sa;pwd=123</span><span style="color: #800000;">"</span>);<span style="color: #008000;">//</span><span style="color: #008000;">连接数据库</span>
            coon.Open();<span style="color: #008000;">//</span><span style="color: #008000;">打开数据库</span>
            SqlCommand cmd = coon.CreateCommand();<span style="color: #008000;">//</span><span style="color: #008000;">创建命令</span>
            cmd.CommandText = <span style="color: #800000;">"</span><span style="color: #800000;">update listview set name=‘</span><span style="color: #800000;">"</span>+name+<span style="color: #800000;">"</span><span style="color: #800000;">‘,pass=‘</span><span style="color: #800000;">"</span>+pass+<span style="color: #800000;">"</span><span style="color: #800000;">‘ where code=</span><span style="color: #800000;">"</span>+Code+<span style="color: #800000;">""</span>;<span style="color: #008000;">//</span><span style="color: #008000;">写命令语句</span>
            cmd.ExecuteNonQuery();<span style="color: #008000;">//</span><span style="color: #008000;">执行命令</span>
            cmd.Dispose();<span style="color: #008000;">//</span><span style="color: #008000;">清空命令</span>
            coon.Open();<span style="color: #008000;">//</span><span style="color: #008000;">关闭数据库</span>
            MessageBox.Show(<span style="color: #800000;">"</span><span style="color: #800000;">修改成功</span><span style="color: #800000;">"</span><span style="color: #000000;">);
            }
        }</span>

 

ListView 连接数据库的增删改查

标签：