Bài viết sưu tầm

        {

            int j = 1;

            listView1.Columns.Add("Stt");

            listView1.Columns.Clear();

            listView1.Items.Clear();

            SqlDataReader reader = lop.Reader("select * from sinhvien");

            for (int i = 0; i < reader.FieldCount; i++)

                listView1.Columns.Add(reader.GetName(i),110);

            listView1.FullRowSelect = true;

            listView1.GridLines = true;

            listView1.View = View.Details;

            listView1.CheckBoxes = true;

            while (reader.Read())

            {

                ListViewItem item = new ListViewItem(j.ToString());

                item.SubItems.Add(reader.GetString(0));

                item.SubItems.Add(reader.GetString(1));

                item.SubItems.Add(reader.GetString(2));

                item.SubItems.Add(reader.GetString(3));

                item.SubItems.Add(reader.GetString(4));

                item.SubItems.Add(reader.GetString(5));

                listView1.Items.Add(item);

                j++;

             }

        }