Question

winform中ListView绑定问题

最简单的绑定 数据总是不对 如图

代码如下

listView1.GridLines = true;
listView1.FullRowSelect = true;
listView1.View = View.Details;
listView1.Scrollable = true;
listView1.MultiSelect = false;
listView1.HeaderStyle = ColumnHeaderStyle.Clickable;

SqlDataAdapter sda = new SqlDataAdapter("select * from Student_Basic", cn);

listView1.Columns.Add("学号",50,HorizontalAlignment.Center);
listView1.Columns.Add("姓名", 50, HorizontalAlignment.Center);
listView1.Columns.Add("性别", 50, HorizontalAlignment.Center);
listView1.Columns.Add("班级", 50, HorizontalAlignment.Center);
listView1.Columns.Add("专业", 150, HorizontalAlignment.Center);
listView1.Columns.Add("职业", 150, HorizontalAlignment.Center);
listView1.Columns.Add("城市", 150, HorizontalAlignment.Center);

DataTable dt = new DataTable();
sda.Fill(dt);

for (int i = 0; i < dt.Rows.Count;i++ )
{
ListViewItem itme = new ListViewItem();
itme.SubItems.Clear();
itme.SubItems.Add(dt.Rows[i][0].ToString());
itme.SubItems.Add(dt.Rows[i][1].ToString());
itme.SubItems.Add(dt.Rows[i][2].ToString());
itme.SubItems.Add(dt.Rows[i][4].ToString());
itme.SubItems.Add(dt.Rows[i][6].ToString());
itme.SubItems.Add(dt.Rows[i][8].ToString());
itme.SubItems.Add(dt.Rows[i][13].ToString());
listView1.Items.Add(itme);
}

Answer 1

看注释部分：
for (int i = 0; i < dt.Rows.Count;i++ )
{
ListViewItem itme = new ListViewItem();
itme.SubItems.Clear();
itme.SubItems.Add(dt.Rows[i][0].ToString());//这句改为item.text = dt.Rows[i][0].ToString()
itme.SubItems.Add(dt.Rows[i][1].ToString());
itme.SubItems.Add(dt.Rows[i][2].ToString());
itme.SubItems.Add(dt.Rows[i][4].ToString());
itme.SubItems.Add(dt.Rows[i][6].ToString());
itme.SubItems.Add(dt.Rows[i][8].ToString());
itme.SubItems.Add(dt.Rows[i][13].ToString());
listView1.Items.Add(itme);
}

Answer 2

这要看你数据表的结构了