图例

image.png
image.pngimage.png

  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using System.Data.SqlClient;
  12. namespace DataBind_ListView
  13. {
  14.     public partial class Form1 : Form
  15.     {
  16.         public Form1()
  17.         {
  18.             InitializeComponent();
  19.         }
  21.         private void btnBindData_Click(object sender, EventArgs e)
  22.         {
  23.             // 连接数据库
  24.             SqlConnection myCon = new SqlConnection();
  25.             myCon.ConnectionString = "Data Source=DESKTOP-VFJD28I;" +
  26.                 "Initial Catalog=db_Class;" +
  27.                 "Integrated Security=True";    // 这个数据库连接字符串在左侧服务器资源管理器-数据连接下-右击属性找到复制粘贴到这里
  28.             myCon.Open();
  30.             // 使用 SqlCommand 提交查询命令
  31.             SqlCommand selectCMD = new SqlCommand("SELECT top 10 SNo,SName FROM tb_Student", myCon);
  33.             // 创建SqlDataReader
  34.             SqlDataReader dr = selectCMD.ExecuteReader();
  35.             listView1.View = View.Details;  // 设置显示模式
  36.             listView1.FullRowSelect = true;
  38.             // 将 DataReader 中的数据绑定到 ListView1
  39.             while (dr.Read())
  40.             {
  41.                 ListViewItem lv = new ListViewItem(dr[0].ToString());
  42.                 lv.SubItems.Add(dr[1].ToString());
  43.                 listView1.Items.Add(lv);
  44.             }
  45.             dr.Close();
  47.             // 断开连接
  48.             myCon.Close();
  50.         }
  52.         private void btnClearData_Click(object sender, EventArgs e)
  53.         {
  54.             listView1.Items.Clear();
  55.         }
  56.     }
  57. }