使用ListView控件展示数据

来源：互联网发布：python中关键字参数编辑：程序博客网时间：2024/05/28 23:10
  课后作业五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 Form1 : Form    {        public Form1()        {            InitializeComponent();        }    private void button2_Click(object sender, EventArgs e)        {            run();        }        public void run()        {            string and = "Data Source=.;Initial Catalog=ent;Integrated Security=True";            SqlConnection conn = new SqlConnection(and);            conn.Open();            if(listView1.Items.Count>0){                listView1.Items.Clear();            }            StringBuilder sql = new StringBuilder();            sql.AppendLine(" select Name,Type,Number,Price  ");            sql.AppendLine(" from dbo.Table_1 ");            sql.AppendFormat(" where Type like '%{0}%'",this.comboBox1.Text.Trim());            try            {                SqlCommand command = new SqlCommand(sql.ToString(), conn);              //  conn.Open();                SqlDataReader reder = command.ExecuteReader();                if (!reder.HasRows)                {                    MessageBox.Show("没有要查找的记录", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                }                else                {                    while (reder.Read())                    {                        string name = reder["Name"].ToString();                        string type = reder["Type"].ToString();                        string number = reder["Number"].ToString();                        string price = reder["Price"].ToString();                        ListViewItem tem = new ListViewItem(type);                        tem.SubItems.Add(name);                                              tem.SubItems.Add(number);                        tem.SubItems.Add(price);                        listView1.Items.Add(tem);                    }                }                reder.Close();            }            catch(Exception e)            {                MessageBox.Show(e.Message);                MessageBox.Show("系统出现错误","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);            }            finally            {                conn.Close();            }        }        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)        {            run();        }           }}
0 0