private void Form1_Load(object sender, EventArgs e) { listView1.Items.Clear(); listView1.Columns.Add("选择");//listView1的CheckBoxes属性为true; listView1.Columns.Add("编码"); listView1.Columns.Add("姓名"); listView1.Columns.Add("性别"); listView1.Columns.Add("身份证号"); listView1.Columns.Add("单位名称"); listView1.Columns.Add("报考时间"); listView1.View = View.Details; MyDBase DB = new MyDBase(DBUser.sserver, DBUser.DBName, DBUser.suser, DBUser.spasswd); SqlDataReader RD = DB.DBDataReader("select * from view_S"); while (RD.Read()) { ListViewItem lv = new ListViewItem(); lv.SubItems.Add(RD["编码"].ToString()); lv.SubItems.Add(RD["姓名"].ToString()); lv.SubItems.Add(RD["性别"].ToString()); lv.SubItems.Add(RD["身份证号"].ToString()); lv.SubItems.Add(RD["单位名称"].ToString()); lv.SubItems.Add(RD["报考时间"].ToString()); listView1.Items.Add(lv); listView1.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);//根据内容调整列宽 } DB.DBClose(); }
listView控件绑定SQL Server数据库,布布扣,bubuko.com
原文:http://blog.csdn.net/lucky51222/article/details/20999165