使用ListView控件展示数据

最新推荐文章于 2020-12-01 08:47:19 发布

柠檬不萌耶

最新推荐文章于 2020-12-01 08:47:19 发布

阅读量550

点赞数

本文链接：https://blog.csdn.net/qq_36074150/article/details/53504906

版权

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication1
{
    public partial class tianjia : Form
    {
        public tianjia()
        {
            InitializeComponent();
        }

        private void bigg_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.LargeIcon;
        }

        private void xiao_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.SmallIcon;
        }

        private void xiangxi_Click(object sender, EventArgs e)
        {
            this.listView1.View = View.Details;
        }

        private void tianjia_Load(object sender, EventArgs e)
        {
            run();
            //ListViewItem fell = new ListViewItem("didida",6);
            //fell.SubItems.Add("120G");
            //fell.SubItems.Add("本地磁盘");
            //fell.SubItems.Add("80G");
          //  fell.SubItems.AddRange(new string[]{"450G","D磁盘","120G"});
          //  listView1.Items.Add(fell);


        }

          private void button1_Click(object sender, EventArgs e)
          {
              run();
          }



        public void run()
        {
            if (listView1.Items.Count>0) 
            {
                listView1.Items.Clear();
            }



            string ent = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";

            SqlConnection conn = new SqlConnection(ent);
            conn.Open();

            StringBuilder sql = new StringBuilder();
            sql.AppendLine("select s.[StudentNo],s.[StudentName],s.[Sex],G.[GradeName]  ");
            sql.AppendLine("  from dbo.Student as s, dbo.Grade as G  ");
            sql.AppendLine("  where s.[GradeId]=G.[GradeId]  ");
            sql.AppendFormat("  and s.[StudentName] like '%{0}%'",this.textBox1.Text.Trim());

            //查询并显示
            DBHelper per = new DBHelper();

            try
            {
                SqlCommand command = new SqlCommand(sql.ToString(),per.Connection);

                per.OpenConnection();
                          
                SqlDataReader rader = command.ExecuteReader();

                //如果没有数据行,将弹出提示
                if (!rader.HasRows)
                {
                    MessageBox.Show("没有要查找的记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    while (rader.Read())
                    {
                        string studentNo = rader["StudentNo"].ToString();
                        string studentname = rader["StudentName"].ToString();
                       string  genderld = rader["sex"].ToString(); //性别的值
                      

                        string gradname = rader["GradeName"].ToString();

                        //创建 ListViewItem
                        ListViewItem tem = new ListViewItem(studentNo);

                        //添加子项
                        tem.SubItems.Add(studentname);
                        tem.SubItems.Add(genderld);
                        tem.SubItems.Add(gradname);
                        listView1.Items.Add(tem);

                    }
                }
                rader.Close();

            }
            catch(Exception)
            {
                MessageBox.Show("系统出现错误","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
            }
            finally
            {
                per.CloseConnection();
            }


        }

    
        

    }
}

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace WindowsFormsApplication1
{
    /// <summary>
    /// 此类维护数据库连接字符串，和 Connection 对象
    /// </summary>
  public  class DBHelper
    {
        // 数据库连接字符串
        private string connString = @"Data Source=.;Initial Catalog=MySchool;Integrated Security=True";

        // 数据库连接 Connection 对象
        private SqlConnection connection;

        /// <summary>
        /// Connection对象
        /// </summary>
        public SqlConnection Connection
        {
            get
            {
                if (connection == null)
                {
                    connection = new SqlConnection(connString);
                }
                return connection;
            }            
        }

        /// <summary>
        /// 打开数据库连接
        /// </summary>
        public void OpenConnection()
        {
            if (Connection.State == ConnectionState.Closed)
            {
                Connection.Open();
            }
            else if (Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
                Connection.Open();
            }
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void CloseConnection()
        {
            if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
            }
        }
    }
}