listview控件

 private void listview_Load(object sender, EventArgs e)
        {
            string sql = string.Format("select LoginId,StudentName,UserStateId,Sex from Student where LoginId like '%{0}%'", textBox1.Text);
            string connStr = DBHelp.connStr;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                conn.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                while(dr.Read())
                {
                    ListViewItem item = new ListViewItem(dr[0].ToString());
                    string active=dr[2].ToString()=="1"?"活动":"非活动";
                    item.SubItems.AddRange(new string[]{dr[1].ToString(),active,dr[3].ToString()});
                    listView1.Items.Add(item);
                }
                dr.Close();
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            listView1.Items.Clear();
            string sql = string.Format("select LoginId,StudentName,UserStateId,Sex from Student where LoginId like '%{0}%'", textBox1.Text);
            string connStr = DBHelp.connStr;
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                conn.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    ListViewItem item = new ListViewItem(dr[0].ToString());
                    string active = dr[2].ToString() == "1" ? "活动" : "非活动";
                    item.SubItems.AddRange(new string[] { dr[1].ToString(), active, dr[3].ToString() });
                    listView1.Items.Add(item);
                }
                dr.Close();
            }
        }

**************************************************************************************

1.编辑列时候“视图”选择“Details”

2.可以将方法封装为方法!具体代码略